Forum Discussion
How to create a refresh date column in a dataset?
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.
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.