Datestamp data each day

[TSchmidt]

Hello,

I currently have an excel source where supplier managers of my organisation update rates on their suppliers. This means there are no date stamp on their input since they update the same data to current valid rates.

I am currently tasked to do daily calculations based on these rates but without a date structure i wont be able to compute up against other tables where the rates might have changed in the past.

Is it possible to capture the rate data once each day and datestamp it in PowerBI? Or would you rather suggest i modify the source with date data?

Example

On a given day the data might look something like this:

SupplierID	SupplierRate
11111	8,5
22222	6,8
33333	5,3

Another day some of the rates might have changed:

SupplierID	SupplierRate
11111	8,9
22222	6,8
33333	5,3

I am looking to date stamp the table each day:

SupplierID	SupplierRate	Date
111111	8,5	01-01-2022
222222	6,8	01-01-2022
333333	5,3	01-01-2022
111111	8,9	02-01-2022
222222	6,8	02-01-2022
333333	5,3	02-01-2022

Looking forward hearing any suggestions.

Best Regards

[amitchandak · Accepted solution]

@TSchmidt , You can add a column using fixed localdatetime

https://docs.microsoft.com/en-us/powerquery-m/datetime-fixedlocalnow

And then try for dax append method 

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[TSchmidt]

Hi @amitchandak ,

Thank you very much for your suggestion. I followed the blog from Chris Webb and now i got a table which snapshots and datestamps the data each day. 

Appreciate your assistance!

Best regards