Power BI From and To Date Filtering with One Slicer

It happens that you might have two fields as From and To date (or Start and End date) in your dataset, and you want a date slicer in the report. The date slicer has to filter records in a way that the FROM and the TO dates are in the range of dates selected in Read more about Power BI From and To Date Filtering with One Slicer[…]

Power BI Icon Names for Conditional Formatting Using DAX

I have previously written about conditional formatting in Power BI, and how you can take one step further with using DAX to dynamically change the conditional formatting. Conditional formatting with DAX for colors is easy, you can use the color name or their hex code. But for Icons, it is slightly different. You can either Read more about Power BI Icon Names for Conditional Formatting Using DAX[…]

ConcatenateX in Power BI and DAX: Concatenate Values of a Column

It happens often in Power BI calculations and reports that you need to concatenate a list of values from a column. You can do this concatenation in Power Query or DAX. However, if the concatenation needs to be done dynamically. ConcatenateX is a very helpful DAX function to achieve such results. It is very helpful Read more about ConcatenateX in Power BI and DAX: Concatenate Values of a Column[…]

Power BI Pattern: Find Start and End Date of Task from Children

The project and task planning management systems have the concept of each task starting and ending with a date. Tasks can be a child of other tasks, and the parent tasks should take the whole range that the child task’s date includes. You need to parse the parent-child hierarchy of tasks (which can be many Read more about Power BI Pattern: Find Start and End Date of Task from Children[…]

Power BI Date or Calendar Table Best Method: DAX or Power Query?

So you want to create a date or calendar table in Power BI, and you search for ways to do that. Then you will find many different approaches for that. Some of the approaches are using Power Query, some are using DAX. Which method is the best? What is the actual difference between a date Read more about Power BI Date or Calendar Table Best Method: DAX or Power Query?[…]

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[…]