Tag: DAX Calculations

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

The Ultimate DAX Guide For Beginners

The third pillar in Power BI development is DAX calculations. This tutorial contains a thorough DAX guide for beginners covering the basics on formatting and editing. Frequently used DAX functions are also included in the discussion. DAX Editor Guide Before anything else, here are some DAX Editor tips you need to know: Use Ctrl +

Continue reading

DAX Language Power BI Tutorial On Reverse TOPN

In this blog post, we are going to take a look at a question that was asked on the Enterprise DNA forum and use a DAX language Power BI technique to solve it. In case you want to follow along and download the files, just visit the Enterprise DNA forum and go to this link.

Continue reading

Power BI Development Techniques Using DAX Patterns | Enterprise DNA

For this blog, I’d like to give you 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 to develop more quickly inside Power BI. I’ve observed many areas of inefficiencies around

Continue reading

DAX Function COLUMNSTATISTICS In Power BI

I’d like to continue exploring the dynamic uses of the DAX function COLUMNSTATISTICS() – a new, almost entirely undocumented DAX function added to Power BI in August 2021 that has some very unique aspects that I think will be very interesting to get familiar with. You can watch the full video of this tutorial at

Continue reading