Forum Discussion
manoj_babu
3 years agoFrequent Visitor
How to create new column for new data (SCD3)
Hi all, I have a table (Example with user name , and due date), The user need to update the due date in the source, I need to create a column so that i can also track the old due date, as in SCD...
amitchandak
Super User
3 years agomanoj_babu , Refer the video on guyincube
https://www.youtube.com/watch?v=tKeaQpWynzg
https://www.youtube.com/watch?v=E1ZABKBpkdg
https://www.zartis.com/scd-implementation-with-temporal-tables-in-power-bi/
- manoj_babu3 years agoFrequent Visitor
amitchandak Thanks for the update. But the solution which you have given, uses only the historical data already available.
I need something like for example, the user updates the new due date in the source excel file, the pbi should take both older date and updated new date into its table.