Power BI: DAX Function USERELATIONSHIP Explained
In the Power BI Desktop, you are allowed only 1 active relationship between tables in your data model. Many times this is all...
Power BI: Use Bookmarks To Make It Easy For End-Users To Reset Filters
Slicers are great in Power BI reports because they allow for the end-users to see the data filtered in any way they see fit.....
Power BI Desktop April 2021 Updates
Another month and another Power BI Desktop update. What does April 2021 have in store? Keep reading.In the April 2021 edition,...
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 a...
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 return...
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 receive...
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 on...
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 it...
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 a...
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 of...
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 in...
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 last 5...
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 and...
Leave a comment