Tag: DAX Measures

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

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

Power BI DAX Measures For Events In Progress

In this tutorial, I’m going to show you how to create Power BI DAX measures for events in progress. These events could come in the form of orders in progress or sales in progress, depending on the nature of your report. Basically, the challenge here is calculating results when there is more than one date

Continue reading

Power BI Progress Tracker For Sales And Order Data

This tutorial will show how to create a Power BI progress tracker for sales and order data. You’ll learn how to solve a scenario where you have more than one date in your Fact table. This is the Sales table that will be used in this tutorial. You can see that it has two date

Continue reading

Choose Specific Date In Power BI Using DAX Calculation

This tutorial will discuss about choosing a specific date in your Power BI data reports. The material used in this tutorial comes from the Enterprise DNA Forum. You’ll learn how to solve the problem and understand the methods used. You may watch the full video of this tutorial at the bottom of this blog. Understanding

Continue reading