Forum Discussion
How to create a refresh date column in a dataset?
Hi everyone,
I want to get data from salesforce and compare it dinamically with snapshots from previous weeks.
Is there a way to create a column that brings me the refresh date for each snapshot?
What I imagine is to automatically append the data after each refresh and to add an index column, so i can easily compare the data from the different snapshots.
Thanks.
Hi Anonymous ,
1.From Power BI, choose Blank Query, rename the query to Last Refreshed Date, and then enter the following formula into the function bar.
2.To convert the date data to a table format, choose To Table and select the To Table option.
A single column appears with the date.
3.From the Transform menu, choose Change Data Type and select the Date/Time option.
4.Rename Column1 to something more meaningful, such as Last Refresh Date.
5.From the Home menu, choose Close and Apply.
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.
2 Replies
- amitchandak
Super User
Anonymous , This method is dicussed for snapshot approch, refer if this can help
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 Anonymous ,
1.From Power BI, choose Blank Query, rename the query to Last Refreshed Date, and then enter the following formula into the function bar.
2.To convert the date data to a table format, choose To Table and select the To Table option.
A single column appears with the date.
3.From the Transform menu, choose Change Data Type and select the Date/Time option.
4.Rename Column1 to something more meaningful, such as Last Refresh Date.
5.From the Home menu, choose Close and Apply.
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.
