Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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 , 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/
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |