USERNAME() and USERPRINCIPALNAME() can be used in various ways. However, In this post, we will look at two Power BI functions, USERNAME() and USERPRINCIPALNAME(). To extract either the first name or the user’s last name, they differ when using Power… Read More ›
USERNAME() and USERPRINCIPALNAME() can be used in various ways. However, In this post, we will look at two Power BI functions, USERNAME() and USERPRINCIPALNAME(), to extract either the first name or the user’s last name see how they differ when… Read More ›
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 ›
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 ›
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 ›
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 ›