Demystifying Date Dimension Part 4

Let us pick up where we left off. In part 3 we created a date table but in a very brute force method. Let us make this more dynamic in this series. If you followed me every step of the way you should already have this in your table. If not then just click onContinue reading “Demystifying Date Dimension Part 4”

Power BI Date Dimension Demystified Part 2

Hello All, Let us continue with our journey of demystifying the Date Table. In my last post, we learned to use CALENDARAUTO() function. We will continue today with the second DAX function called Calendar(). We will also look at how to extract other “relevant columns” such as year, month name, month number, etc. I willContinue reading “Power BI Date Dimension Demystified Part 2”