Tag: Advanced DAX

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 previous week values that can be useful additions to your toolbox, one using DAX and another one using Power Query. You

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

Row Context And Filter Context In A Power BI DAX Code

In this tutorial, we’re going to take a look at a piece of DAX code that you might have written in your DAX journey. You might also have been confused as to how this code is actually working, and how both Row Context and Filter Context seem to be interacting with each other in just

Continue reading

Power BI Modulo and Integer-Divide DAX Functions

I thought it’d be interesting to find a way to highlight functions and operators in Power BI that you may haven’t come across before, deeply buried in the menus, or those that you may have seen, but don’t really know what they do. For this tutorial, I’d like to highlight the Power BI Modulo and

Continue reading

Power BI Development Techniques Using DAX Patterns | Enterprise DNA

For this blog, I’d like to give an overview of how you can speed up your Power BI development. I always think about ways on how we, at the Enterprise DNA community, can empower ourselves and the Power BI community, in general, to develop much quicker inside of Power BI. I observed many areas of

Continue reading