cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TSchmidt
New Member

Datestamp data each day

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:

SupplierIDSupplierRate
111118,5
222226,8
333335,3

 

Another day some of the rates might have changed:

SupplierIDSupplierRate
111118,9
222226,8
333335,3

 

I am looking to date stamp the table each day:

SupplierIDSupplierRateDate
1111118,501-01-2022
2222226,801-01-2022
3333335,301-01-2022
1111118,902-01-2022
2222226,802-01-2022
3333335,302-01-2022

 

Looking forward hearing any suggestions.

 

Best Regards

 

1 ACCEPTED SOLUTION
2 REPLIES 2
amitchandak
Super User
Super User

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

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!