Define updating/modifying time as a timepoint

[javadjafari]

Hi friends,
I have connected an excell file as my database on the sharepoint to the Power Bi and then refresh it as I add new subjects with different IDs to the spreadsheet weekly. Now, I need to compare the number of subjects with the previous report and have a trend (increase or decrease) in that number based on each update (consider the updates as timepoints as I do not have any other date as reference), if anyone can advise please. Hope it is clear. Thanks in advance.

[v-stephen-msft]

Hi @javadjafari ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @javadjafari ,

Please refer to two articles which teaches you to add a column with the the last refresh date of the dataset

Create a column in Power BI for last refresh date

Add a Refresh Time Stamp To Your Power BI Reports

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.