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. I discovered this approach from the Enterprise DNA Forum. One of the members actually suggested this technique as a solution to a question on how to
Tag: Date Table
In today’s blog, I’ll discuss a question that comes up all the time in the Enterprise DNA forum. How can you can sort the fields from an extended date table columns properly? This refers to the extended date table from the M code showcase that was developed by Melissa Dekorte, one of our Enterprise DNA
In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. The developer of this report wanted to calculate the percentage difference. However, the developer didn’t want to
I’m going to show you a new approach in creating a date table in Power BI. 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 efficient way to do it. This is actually an approach created by Melissa, one of
I’m going to show you how to keep your practice dataset updated every time you do a refresh. If you really want to improve your DAX skills, the way way is to use it and put it into practice. And to do that, you’d need a practice dataset that helps you visualize and work on