topic Re: SCD Type 2 in DAX Commands and Tips

SCD Type 2

saijesh123 — Fri, 13 Dec 2024 06:49:03 GMT

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

Re: SCD Type 2

BeaBF — Fri, 13 Dec 2024 08:33:23 GMT

saijesh123 Hi! wich is the expected output?

BBF

Re: SCD Type 2

mark_endicott — Fri, 13 Dec 2024 11:00:08 GMT

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-data-to-it-using-incremental-refresh/

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

Re: SCD Type 2

saijesh123 — Fri, 13 Dec 2024 16:24:54 GMT

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

Re: SCD Type 2

uzuntasgokberk — Mon, 14 Jul 2025 13:32:43 GMT

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

Re: SCD Type 2

Anonymous — Mon, 23 Dec 2024 06:58:13 GMT

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