Show date last refreshed on Power BI

[Kalachuchi]

Hello Guys,

I have a dashboard which refreshes every two hours and I want to show when was the dashboard refreshed. 

it will be like last refreshed x hours ago. Depending on when the user has access the dashboard. is it possible?

[VahidDM]

Hi @Kalachuchi 

Please see the below links:

How do you get a REFRESH DATE in your Power BI report???

Create a column in Power BI for last refresh date

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[Kalachuchi]

@VahidDM  hello,

I saw that one before. But instead of showing the dates. it will be shown as for example 3pm refreshed then the user has accessed it at 5pm then the user will see Date Refreshed: 2 hours ago.

[VahidDM · Accepted solution]

@Kalachuchi 
Use NOW code to find current time and then subtract that from Refresh time.

Use below code:

Date Refreshed =
VAR _time =
    NOW ()
RETURN
    FORMAT ( MAX ( Query1[Time] ) - _time, "short time" ) & " ago"

To find the best format and change it, please see the Format function page.

the output will be as below:

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!