Optimizing Rolling Distinct Count Measures
In my new role in Azure Data, I have spent a lot of time optimizing the performance of semantic models and DAX measures. One of the types of calculations we...
2024¶
Creating User-Driven Default Slicer Selections
Recently, in an internal Power BI help forum, someone asked if there was a way to force a slicer's default selection to be based on a particular user's sign in.
Sometimes It's Good to Fail: Raising Errors with Data Quality Tests
Having your dataflows or semantic models fail to refresh can be frustrating, but at least you know that whatever caused the error did not make it into your...
Reducing Semantic Model Size with Creative Solutions
When working with larger semantic models, one of the things you are constantly trying to do is to reduce the model size while still meeting stakeholder...
Enhancing Your Golden Semantic Model with User Input Tables
While learning about Power BI, you are likely to learn that designing a star schema consisting of fact and dimension tables is critical to building a good...
Custom M Function #7: fxReplaceWithDefaultValue
Click here to go straight to the function.
Custom M Function #6: fxSplitCamelCaseColumns
Click here to go straight to the function.
You Don't Know Until You Test It: DAX Optimization
When working with DAX, there are many ways to get the same result, but performance can vary greatly. If you are anything like me, you want your code to be...
Custom M Function #5: fxCumulativeToIncremental
Click here to go straight to the function.
Power Query Level Up: Exploring the Advanced Editor and the M Language
Recently, I had the privilege of delivering my first public training session at the 2024 Global Power Platform Bootcamp where I gave an introduction to the...
