Forum Discussion

manoj_babu's avatar
manoj_babu
Frequent Visitor
3 years ago

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...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, manoj_babu 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with Excel. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • manoj_babu's avatar
    manoj_babu
    Frequent Visitor
    3 years ago

    Hi v-zhangti ,

     

     

    This is the source sample data,

    In this source data, users will update their due date column for example Manoj Updates the due date from 31/12/2022 to 31/1/2023, Then in power BI I need a column with both Old date (31/12/2022) & new date (31/1/2023). 

    I need a table with the all the data including old and new due date. 

    Is there a dax for creating such column or columns?

     

    Thanks in advance