Forum Discussion
Datestamp data each day
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-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
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-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
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