March 2021 – Power Your BI

SCD Type 2 Fact tables in Power bi, Daxing

Posted on 04/09/2021 by Jaouad Safouani

SCD Type 2 Fact tables are rarely used and often are not talked about. Lately, I was introduced to the concept and I was able to decipher this mystery. In the case business logic is to give a report to the business at the end of the month based on a snap shot of how […]

Investments Adviser - Financial WordPress Theme

New Update to CALCULATE Function in DAX

Posted on 04/09/2021 by Jaouad Safouani

One of my favorite items in the March 2021 Power bi release is the update to the calculate function. Now we can use the OR Operator inside the CALCULATE function with out the need of calling the filter function within it.Below code shows an example of how we used to apply the OR Operator within […]