How to handle Slowly Changing Dimension in Power BI

[suman-petlu]

Hi All,

I have Star Schema with 3 Dimensions Table (D1,D2,D3) and 1 Fact (F1).

Out of 3 dimension table D3 is a slowly changing Dimension.

D1,D2 Join with F1 is a straight forward.

D3 Join with F1 as follows

F1.ID = D3.ID AND

F1.Date >= D3.Start_Date AND

F1.Date <= D3.End_Date

Please help how to handle this SCD Type2 Join in Power BI.

Regards,

Suman.

[amitchandak]

@suman-petlu , refer

https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/

https://www.zartis.com/scd-implementation-with-temporal-tables-in-power-bi/

[suman-petlu · Accepted solution]

@amitchandak: Thank you for your response.Will verify and let u know.

Regards,

Suman Petlu