Forum Discussion

shamilka's avatar
shamilka
Frequent Visitor
2 years ago

Need to add a history table for each data refresh

Hi,

 

I need to add a history table with a data refresh date column. So for each data refresh, the refresh date for each row has to be added in a refresh date column. There should not be any duplicates if the coped row is already there. Also, I need to count the number of open days by getting todays date into consideration well as the refresh date. Please check the input as well as desired output table below. 

 

It would be ideal if I can copy data to a new table since I would be able to have a table for current data as well as history data.

 

Input

StatusPNSNBatch noQTYP
InstallABC430011141XXA
RemoveABC320011151XXB

 

Output 

 

StatusPNSNBatch noQTYPRefresh dateOpen days
InstallABC430011141XXA17/04/20240
RemoveABC320011151XXB10/04/20247
Show and Tell

1 Reply

  • dufoq3's avatar
    dufoq3
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi shamilka, you can't store current date but you can do that if your source file contains such date (in filename or body) - it doesn't matter. It can be done in power query but to be honest it is not ideal.