Forum Discussion
SCD Type 2
Hi All,
given source table
| customer id | name | city |
| 1 | A | XYZ |
| 2 | B | ABC |
| 3 | C | KLM |
| 4 | D | ADJ |
| 5 | E | JKL |
Updates table
| customer id | name | city |
| 1 | A | KKL |
| 2 | B | JJK |
I have first table with data changes to city that are made to the data. by updates table
I want to implement scd type 2 in power bi and want to have the history of any changes made to the table .
help me with dax functions to use and track historical changes
5 Replies
EXPECTED OUTPUT
customer id name city FROM TO 1 A XYZ 01-01-2000 01-01-2001 2 B ABC 01-01-2000 05-01-2001 3 C KLM 01-01-2000 NULL 4 D ADJ 01-01-2000 NULL 5 E JKL 01-01-2000 NULL 6 A KKL 02-01-2001 NULL 7 B JJK 06-01-2001 NULL Hello saijesh123 ,
RADACAD shows you how to implement SCD Type 2 (one of the most common types) using Microsoft Fabric and Power BI. That explains well SCD Type2.
https://radacad.com/scd-type-2-in-microsoft-fabric-and-power-biKind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |saijesh123 - You cannot do this with DAX, but this blog might help you do this using incremental refresh:
If this works, please accept as the solution, for others with the same challenge!
Hi saijesh123 ,
Is this issue solved now? If you have any questions, please feel free to share with us.
And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. ๐
Thanks for your understanding!
Best regards,
Lucy Chen
