In today’s blog post, we’ll take another look at the Power Query M function for the extended date table. Since initially posting the code, there have been a number of updates with the help of our Enterprise DNA community. It has grown into quite an extensive date table that pretty much covers everything you’ll likely
In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create useful automation when working on a model with multiple date measures. You can watch the full video of this tutorial at the bottom of this blog. The VALUES function (DAX) returns a one-column table that contains the distinct values from the
In this tutorial, I’m going to talk about Power BI financial year to date calculations. Achieving a year to date analysis of a selected period is quite complex, but I’ll demonstrate to you a formula technique that enables you to quickly create a cumulative total over your specific financial year. You can watch the full
In this blog I’ll show you how you can compare data from different timeframes within the same visualization. You can get amazing Power BI insights using this great technique with time-related DAX. You may watch the full video of this tutorial at the bottom of this blog. I discovered this approach from the Enterprise DNA
I’m going to show you a new approach in creating a date table in Power BI. You may watch the full video of this tutorial at the bottom of this blog. I’ve done so many tutorials about creating date tables over the years, but the new method I’m using now is, by far, the most
