How to Explore Drilling Down and Drill-Through in Power BI  -  AI and Power BI  - Chapter 4

What is special in Power BI with Drill Down/Up, Drill-Through and Expand/Collapse? Drilling down or up is a very interesting feature in any business intelligence tool. Power BI has the same feature but with some twist. In this blog, we…

How to Use Top 3+ Relationship Functions in DAX - DAX in Power BI - Chapter 12

We are going to look at 4 relationship functions in more detail with examples. I found, there are 4 relationship functions in DAX as per Microsoft documentation.  As the name suggested, these functions are for managing and utilizing relationships between…

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 Implement Data Profiling in Power BI – Data Analysis in Power BI – Chapter 3

Data profiling helps to identify data inconsistency. For any data analysis project, we are following CRISP-DM (Cross-industry standard process for data mining) framework. In this framework, data profiling is one of the key steps to start with the project.  In…

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…