Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TSchmidt
Frequent Visitor

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.