Tag: Advanced DAX

The CALCULATE DAX Function: Issues & Solutions

The CALCULATE DAX Function Issues & Solutions - Enterprise DNA

In today’s blog, we will explore why you should not use the CALCULATE DAX function to obtain Average Per Category and provide some alternative solutions to get the same results you want. You can watch the full video of this tutorial at the bottom of this blog. Getting an Average Per Category in DAX is

Continue reading

RANKX Deep Dive: A Power BI DAX Function

RANKX Deep Dive A Power BI DAX Function - Enterprise DNA

Today, we will dive deep into RANKX, a scalar DAX function in Power BI that allows you to return the ranking of a specific number in each table row that forms part of a list of numbers. You can watch the full video of this tutorial at the bottom of this blog. Sample Scenarios We’ll

Continue reading

Power BI Slicers Tutorial: Counting Selections Correctly

Counting Selections Correctly - Enterprise DNA

In today’s tutorial, I’m going to work through a subtle issue with Power BI slicers that can trip you up if you’re not careful. I want to run through it with you in the hopes that if you encountered it, it wouldn’t cause you the same problems. You can watch the full video of this

Continue reading

Get Power BI Previous Week Values Using DAX & Power Query

Retrieving previous period values in Power BI is a common task, but retrieving previous week values requires some special attention. In this tutorial, I’ll discuss two straightforward and versatile methods for obtaining Power BI’s previous week values that can be useful additions to your toolbox – one using DAX and the other using Power Query.

Continue reading

DAX And Power Query | Creating Self-Sorting Columns

Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with this new approach and it worked beautifully. In

Continue reading