Generate Year and Month Combinations in Power BI Report using DAX

A common requirement when reporting data with a Date axis is to be able to see the year and the month in a short form beside each other. Formats such as 2021 Jan, or Jan 2021, or even Jan 21, or 2021-01 are very popular. In Power BI, ideally, you should have a Date dimension Read more about Generate Year and Month Combinations in Power BI Report using DAX[…]

Power BI HR Pattern: DAX Measures for the Last Position to Date: Last Status to Date

One of the common patterns in Power BI is to have a table with different statuses throughout time and then wanting to get the latest status up to a selected date. A simple example of that is to have a table with position(role) changes of employees and then wanting to see their latest position based Read more about Power BI HR Pattern: DAX Measures for the Last Position to Date: Last Status to Date[…]

Book Overview: Power BI DAX Simplified

A few weeks ago, my new book was published and is now available. As the Amazon web page for the book won’t allow me to put some more details about what it is, I thought it better to share some more information about it here. This book is available in all possible Amazon markets as Read more about Book Overview: Power BI DAX Simplified[…]

Explicit Vs Implicit DAX Measures in Power BI

Have you ever tried to connect to a Power BI dataset from Excel using Analyze in Excel? if yes, you might have had this experience that your values don’t show in Excel’s Pivot table as values. This is because those values are not explicit measures, they are implicit measures in Power BI. In this article Read more about Explicit Vs Implicit DAX Measures in Power BI[…]

All in One: Script to Create Calendar Table or Date Dimension using DAX in Power BI

I have previously written an article with the full script of how to generate a date dimension in Power BI using the Power Query script, and I would always recommend that as the first choice. However, sometimes, you just want this to be in DAX way, so here in this blog and video, I explained Read more about All in One: Script to Create Calendar Table or Date Dimension using DAX in Power BI[…]

Basics of DAX Expression in Power BI

There are a lot of resources about how to use each function. However, you always need to start with learning how the expression language works itself. You need to learn how to reference columns and tables. what operators can be used, and what are the very simple basics of writing a DAX expression. In this Read more about Basics of DAX Expression in Power BI[…]

DAX CrossFilter Function in Power BI: Write the Formula both-directional, but keep the relationship single-directional

If you are familiar with relationships in Power BI, you know that there are scenarios that you may need to change the direction of the relationship to a both-directional. A both-directional relationship comes at a cost, which is mainly performance and ambiguity of the model. There is a way to write a calculation in a Read more about DAX CrossFilter Function in Power BI: Write the Formula both-directional, but keep the relationship single-directional[…]

Power BI DAX RelatedTable Function: Get the subtable related to the current row

There are multiple functions that can help when you work with tables that are connected through relationships. One of these functions is Relatedtable. This function gives you the subtable from the other table for all the rows related to the current row. For example, all sales transactions (from the Sales table) for the current customer Read more about Power BI DAX RelatedTable Function: Get the subtable related to the current row[…]

Get a field value from a related table in Power BI: DAX RELATED Function Explained

Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and video, I explained a Read more about Get a field value from a related table in Power BI: DAX RELATED Function Explained[…]

FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations

You can apply filtering to visualization elements. However, sometimes filtering has to be done on specific calculations. This can come in handy especially when you want to compare values of other items with specific items. In this article and video, I’ll explain how to use the FILTER function in DAX to apply a custom filter Read more about FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations[…]