Data modelling and DAX
UPDATE: 15-March-2026 I created a public repo with all my custom visuals, including source code and setup instructions here:https://github.com/dax-tips/CustomVisuals Blog Last week I had the pleasure to attend the Power BI Next Step conference in Copenhagen. I enjoyed it and can highly recommend it. As part of that event, I was invited to a fun … Continue reading Create Custom Visuals in Power BI with GitHub Copilot
I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. The … Continue reading DAX Pareto Calculation
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations
Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop
