Forum Discussion
Nissa23
2 years agoHelper I
How to display my visual with SCD Type 2 data
Hi,
I've done many reaserch before asking my problem here.
I've built my report with a first version where I don't have changes in my dimension table.
Now, I need to change it in order to take in account the slowly changing dimension.
I've created 3 new columns : start_date and end_date, and a 'Current' column with values : 0,1.
I want in my report to keep the historical visualisation. I don't know how to do it?
Can anyone help me with an idea?
Thanks
1 Reply
- AnonymousNot applicable
Hi Nissa23 ,
For a more detailed guide to using SCD Type 2 in Power BI, including how to properly set up models and visual objects, I recommend reviewing the following documentation:
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Best Regards,
Adamk Kong