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”

Power BI Date Dimension Demystified Part 1

Hello All, Today let us take the first step towards demystifying Date Table journey. Date Dimension plays a very important role. Almost always there is a need to perform and derive time-based insights. Few ground rules must be adhered to when it comes to creating a robust date table. These are The date table must contain uniqueContinue reading “Power BI Date Dimension Demystified Part 1”