Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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