How to Work with 17+ Date and Time Functions in DAX - DAX in Power BI - Chapter 11

We are going to look at 23 date and time functions in more detail with examples. As per Microsoft documentation, there are 23 date and time functions are available in DAX. These functions are more or less similar to excel…

How To Differ CALCULATETABLE Over FILTER In DAX — DAX in Power BI — Chapter 10

CALCULATETABLE is more applicable for context transition requirement.  DAX has a different set of functions to manage tables. In this blog, we are going to explore CALCULATETABLE() function. This function helps create and manage tables. Based on Microsoft documentation, the…

How to Handle Parent-Child Hierarchies in DAX — DAX in Power BI — Chapter 9

5 DAX functions solve the parent-child hierarchy problem in a data model. Last two-three months, I am studying DAX deeply and going through different books. During this learning process, I found various interesting functions in DAX. Out of them, the…

How to Calculate Percentages over Hierarchies in DAX — Dax in Power BI — Chapter 8

The information function helps to implement percentage calculations over hierarchies. In different data models, you may have seen hierarchical data. In DAX, we don’t have any straightforward function to calculate over hierarchies. However, there are different ways to handle this…

How to Deal with Time Intelligence Functions in DAX — DAX in Power BI — Chapter 7

I have explained the concept of combining DAX expression with the element of time. A very common term is used in DAX whenever we are building any data model, is Time Intelligence. It is not only combined and organized data…