Hello All, let us take a deep dive into Date Dimension Part 3 However, for the next few blog posts, we will focus on M Query, and we will first work with static values and then modify the M Query… Read More ›
demystify
Demystifying Date Dimension Part 4
Hi all, in this post, let us make a dynamic date dimension. If you followed me every step of the way, you should already have this on your table. If not, click on the blank query and paste the following… Read More ›
Power BI Date Dimension Demystified Part 2
Hello All, let us continue with our journey of demystifying the Date Dimension. 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… Read More ›
Power BI Date Dimension Demystified Part 1
Hello All, today, let us take the first step towards demystifying the Date Table journey. Date Dimension plays a vital role. Almost always, there is a need to perform and derive time-based insights. Few ground rules must be adhered to when it… Read More ›