How to Make Automated Date Table with additional columns in DAX — DAX in Power BI — Chapter 6

Dealing with Automatic Date Table, additional columns in date table and handling multiple date columns in Data Model. For any data analysis project, three questions are mandatory to ask. What happened?Where are we now?What are we going to do? The…

How to Create Joins in DAX with/without Relationships — DAX in Power BI — Chapter 5

Exploring how to combine data from different tables with or without a relationship in DAX. For most cases, we can consider defined standard relationships in DAX calculations as per the data model. But it is not applicable every time. For…

How to Perform Aggregation and Summarization in DAX — DAX in Power BI — Chapter 4

Explain with hands-on how grouping and summarizing information is a powerful feature of Power BI. For any data analysis or business intelligence project, it is the primary requirement to provide summary information from your data in a faster way. If…

How To Apply Context Concept in DAX — DAX in Power BI — Chapter 3

The concept of context enables dynamic analysis while creating DAX formulas. Experts are saying that if you learn about the context in DAX, then you are going to be a master in DAX. I am following their path and start…

How to Create Variables in DAX — DAX in Power BI — Chapter 2

Learn how to use DAX variables in Power BI to make calculations easier to understand and for improved readability, consistency and performance. When I was studying DAX, I realized how variables are helping to improve performance, readability and reduce the…