DAX Archives - Master Data Skills + AI

How To Get Your Dataset’s Top N In Power BI

In today’s blog, we will walk you through the process of using Quick Measures Pro to create a custom...

Many people believe that we cannot perform Power BI custom sort using DAX, but that is not true. DAX...

In today’s blog, we will explore why you should not use the CALCULATE DAX function to obtain Average...

In this tutorial, you’ll learn how the CROSSJOIN function works in DAX using the Server Timings pane...

Today, we will dive deep into RANKX, a scalar DAX function in Power BI that allows you to return the...

In this tutorial, you'll learn what a data cache is and why it's important. A data cache stores bits of...

Retrieving previous period values in Power BI is a common task, but retrieving previous week values...

The third pillar in Power BI development is DAX calculations. This tutorial contains a thorough DAX...

Following a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded...

In this tutorial, we’re going to take a look at a piece of DAX code. You may have already used...

This tutorial will show how to create a Power BI progress tracker for sales and order data. You’ll...

This tutorial will discuss about how to import and open an Excel file with multiple sheets to one Power...