A game changing feature came out this year. It’s the native Git integration in Power BI. It’s the feature that so many Power BI professionals have been waiting for. Previously, we still had a solution for implementing version control in Power BI, thanks to open source tools such as pbi-tools. But it was not easy…
Category: Business Intelligence

The Difference Between LASTNONBLANK and LASTNONBLANKVALUE in DAX
There are so many useful functions in DAX, however, there are also some functions that are not too intuitive to understand. I’ll cover such functions particularly LASTNONBLANK() and LASTNONBLANKVALUE() in the blog post. Note that the difference I explain in this blog post also applied to FIRSTNONBLANK() and FIRSTNONBLANKVALUE() I use Contoso dataset in DAX.do…

How to Create a Hex Map in Power BI
Learn how to create a hex map in Power BI

Format All DAX Measures at Once
There are tools that help you format your DAX code such as Tabular Editor and daxformatter.com. They can only format your DAX one by one. Have you ever found yourself doing that before? Then this blog post is for you. With C# scripting in Tabular Editor, you can format your DAX measures all at once!…

What are Power BI Dataflows?
The Simplest Guide for Power BI Dataflows There are resources out there explaining what dataflows are in Power BI. But they often include some jargon and are not straight to the point. I simplified as much as I can so that you spend less time in understanding what they are and when you should use…

Calculate the Max Sales Amount for Product
Setup I use the Contoso data model. You can access it dax.do or download pbix here. The data model looks like this: Code The result looks like this: Validating the output: Here’s the full code I used in dax.do: Explanation VALUES() gets unique products from product table. You could just reference the table, but I…

Calculate Average Sales Per Customer with DAX in Power BI
Calculate Average Sales Per Customer in a DAX Measure In any business intelligence tool, there is a need to calculate the average of a metric per data grain like customer or user. To many Power BI users, it’s not as intuitive as creating a simple measure calculating the average of sales. In this blog post,…

Best Power BI Books You Should Read
Best Power BI books I recommend you read

Best Data Visualization Books You Should Read
A list of best data visualization books you should read

What is Self-Service Analytics?
Learn what you need to implement successful self-service analytics