SCD Type 2

[saijesh123]

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

[Anonymous]

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

[uzuntasgokberk]

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-bi

Kind 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]

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

[mark_endicott]

@saijesh123 - You cannot do this with DAX, but this blog might help you do this using incremental refresh:

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

If this works, please accept as the solution, for others with the same challenge!

[BeaBF]

@saijesh123 Hi! wich is the expected output? 

BBF