Let's Get Organized With Power BI
Organization for me is always a priority. When things are not in the right place and I can’t find something quickly I get...
Power BI: Use DAX Switch Function to Make IF Functions Easier
The IF function in DAX is a very popular logical function. It will perform a logical check on a value expression and produce...
Power BI DAX: Running Totals Using Variables, CALCULATE, and FILTER
Recently after a private training, I had a follow-up email from one of the participants. He asked if there was a way to...
Power Apps: Safeguard Deleting Records
Often times after showing how you can delete a record in Power Apps I will see some nervous faces in the crowd. Even if that...
Power Apps and Power Automate: Send Emails and Format Dates
Power Apps is great for allowing users to create new records that get submitted to a data source. A question I normally...
Power Apps: Sum Function and Collections (Basic and Advanced)
As a former Algebra and Algebra 2 teacher, I dealt with summing up numbers on a daily basis. In Power Apps, we might forget...
Power Apps Filter Records For Logged In User
During my training session with Power Apps, I'm often asked if you filter the records shown in a gallery to only show based...
February 2021 Power BI Desktop Updates
The first update of 2021 is out for the Power BI Desktop program is out. January didn't have any updates, but February made...
Power Apps: Advanced Filtering and Delegation Warnings
In my last blog and video, I demonstrated how you can filter the records showing in a gallery using a drop-down...
Power Apps: Filtering Made Easy
While conducting training with Power Apps, one of the most common questions I receive from those in attendance is does Power...
Best Practice To Trim Before Removing Duplicates or Merging In Power Query Editor
In last week’s blog, I wrote and did a video about how to remove duplicate records and keep the most recent entry as long as...
Remove Duplicates And Keep Most Recent Records in Power BI
A week ago in my last training, I was demonstrating how to get rid of duplicate records when making a dimension table. One...
Disable/Enable Buttons and Wipe Out Values With Patch
In last week's blog/video, I showcased how you can use the patch function to create a record without using the preset forms...
Getting Started With Robotic Process Automation (RPA) Using The Power Automate Desktop
There are a lot of hot phrases you’ve likely heard thrown around during various keynote sessions at conferences over the...
Create A Record Without A Form In Power Apps Using PATCH
In Power Apps, forms are great to use to submit data to be recorded in your data source. They do not take long to set up...
Leave a comment