How to modify Dynamic Format Strings in Power BI
I was recently testing out and using the great new Power BI feature using dynamic format strings in Power BI. What I found that currently it is not possible or easy to modify an existing dynamic format string. In this blog post below I show you how I managed to modify the dynamic format string, so that you do not…
How to use the Power BI DAX Debug Output when testing EvaluateAndLog
I have seen a few great blog posts with regards to the new DAX function EvaluateAndLog which can be used to show/debug what happens with DAX Measures. When I tried this out myself one of the challenges I had was where to download DaxDebugOutput, and then how to use it with Power BI Desktop. In this blog post I will…
Exporting a Power BI Visual data to a CSV File in SharePoint
In this blog post I am going to demonstrate how to use the new Power Automate Flow to extract data from a DAX measure into a SharePoint CSV file. I got this idea after reading the blog post from the Microsoft Power BI Team: Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Power BI Blog…
DAX – Getting Distinct Count on Dimension table for Offices that have had Sales
I had a challenge when I was looking to get the Distinct Count of Offices only for the Offices that had Sales. The reason for this measure is to get the % out of all Offices who had Sales. Below is how I solved this. What I did first was to create the following measure, the issue was that this…
How did I keep my Power BI dataset measures documented and up to date?
One thing that often happens is when users are using a dataset, they want to know which measures are available. And not only that sometimes they want to know the measure definition. This got me thinking and how best could I give this to the users in my organization to be able to find this information quickly and easily. In…
Using PowerShell to run Power BI DAX queries and extract data to CSV
In this blog post I am going to show you how to use PowerShell to run a DAX query from my dataset, and then store the results in a CSV file. I will also include the PowerShell code! I really liked the awesome blog post by Kay on the Power BI Team which you can find here: Announcing the public…
How to get multiple slicer items filtered using the DAX TREATAS function
Quite often I wanted to get the data a slicer quickly and easily where multiple items are selected. I then wanted to use the slicer items to filter my measure. The first thing that I did was to manually hard code the values to make sure that I was getting the correct values with the following measure below. EVALUATE ROW…
Get Power BI Desktop to write the DAX for you
Recently I had to get some data from a Power BI Dataset. At first, I started writing the DAX using the fantastic DAX Studio. Then a thought occurred to me, what if I could get the DAX already written and change it to my requirement. This would save me a lot of time and effort. I love the quote from…
Using DAX to calculate Cumulative Target amount split into individual months
I had a requirement to take the overall target amount and split it for each month. But also, for it to be cumulative for each month going forward. The Target amount was 600,000 per month This is what the DAX measure looked like Target by Month = VAR MyTarget = 6 * 6000000 VAR TargetPerMonth = DIVIDE ( MyTarget, 6…
A Real implementation of Approximate Distinct Count vs DISTINCTCOUNT is 7X faster!
I am very fortunate to have known Phil Seamark for quite some time. And quite a while ago we were chatting, and Phil mentioned that he had this idea that he could get an approximate distinct count working where it could be VERY close to the actual DISTINCTCOUNT (Using DAX) If you are unaware one of the most expensive DAX…