Forum Discussion
Visual
Hi all I want to create a visual that shows the date the dashboard was refreshed. Something like; Latest Update was: 09/092020 Thanks in advance
Hi Anonymous ,
Create a Blank Query in Query Editor using the below formula.
= #table(type table[Last Refresh Date=datetime], {{DateTime.LocalNow()+#duration(0,2,0,0)}})https://docs.microsoft.com/en-us/powerquery-m/sharpduration
"#duration(0,2,0,0)"
This parameter is to add the time difference to the local time. The specific value is based on the time difference between your local time and the UTC time.
Best Regards,
Jay
Hi Anonymous ,
Create a Blank Query in Query Editor using the below formula.
= #table(type table[Last Refresh Date=datetime], {{DateTime.LocalNow()+#duration(0,2,0,0)}})https://docs.microsoft.com/en-us/powerquery-m/sharpduration
"#duration(0,2,0,0)"
This parameter is to add the time difference to the local time. The specific value is based on the time difference between your local time and the UTC time.
Best Regards,
Jay