Data modelling and DAX
When troubleshooting a slow DAX query, the right diagnostic bundle is worth a hundred screenshots. That bundle is a DAXX file, generated from DAX Studio. It captures the query, the server timings, the query plan, and a VertiPaq Analyzer snapshot of your model, all in one package, and without any of your actual query results. Perfect … Continue reading How to Generate a DAXX File for Performance Tuning
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
Using DAX to help group and count the last known state I got asked recently to help with a DAX measure for an interesting problem in the inventory domain. The requirement is to generate a chart showing the count of the last known State of a given number of items. Here is a walkthrough of … Continue reading DAX : Count number of last known state
For this article, I want to share a way for you to create your own Power BI “Helper Tool” and register it as an external tool in Power BI. This article carries on from some of my recent articles on how you can use Visual Studio Code to help automate specific tasks by taking advantage … Continue reading Use Visual Studio Code to create Power BI External Tool
