Compare DAX and M formulas in Visual Studio Code is really easy with the help of Power BI Sidetools. As it is possible to transfer DAX and M formulas from Power BI desktop to files and to open them in Visual Studio Code, it is possible to compare two files. That’s extremely useful in many cases.
There are scenarios where username or userprincipalname required to use to give access but to use USERPRINCIPALNAME()dynamically and come with the different possibility.
Scenario 1 : In any Organisation each employee belongs to different department and have access as per his designation. An Executive always have access to all data which is related to his employee and a Manager to his department but not to the data which belongs to Executive and similarly Lower Level employee will have access to his data only.
Scenario 2. A User exists with multiple users in the same row.(Additional Example how we can use the USERPRINCIPALNAME( ))
Customer retention refers to the ability of a company or product to retain its customers over some specified period. There are many ways to measure the data. In the last blog (blog link), we have checked MoM (Month on Month) Retention. Here, we will go through Period over Period or POP.