Forum Discussion

Tatpuje_apurva's avatar
Tatpuje_apurva
New Member
2 years ago

How to apply incremental load with dimension table with Last updated date in power BI

Hi All,

I want to apply incremental load to dim Customer Table where we have last updated date present.

We are not maintaining history in Dim customer for example 

Customer NamelocationSales Representative Last Updated Date
ApurvaIndiaABC20/3/2016
EhtheshamUSXYZ24/4/2020
SanjayUAEMNQ5/6/2024

 when we are updating dim customer table for Apurva. Lets say Sales Representative for apurva got changed form ABC to STU

then record got replaced with changed in Last Updated Date.Please refer below updated table.How to apply incremental Load for same.

Customer NamelocationSales Representative Last Updated Date
ApurvaIndiaSTU7/2/2024
EhtheshamUSXYZ24/4/2020
SanjayUAEMNQ5/6/2024
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Tatpuje_apurva ,

     

    If you have a date on the table has you present on your data example the you can do it in the same way you do like any other table, linking the incremental to the Last update date