Display current date and time

[melina]

Hi all,

I want to show current date and time in my report and dashboard. I have use measure DateTime = NOW()+ (8/24). But when i view in my report, the system show wrong current time. It only correct when i published to the web services, but still need to refresh every time. Is there any alternative way if i want to show correct current date and time in report and  web services without need to refresh everyime?

Thanks!

[rommel20 · Accepted solution]

Create Column instead of measure 

[Column]   Get Date = NOW()

[Measure]   Last Date Refreshed = "Last Refreshed :" & MAX(Table[Get Date]) + (10/24)

+ 8/24 - for  beijing, hongkong etc.

+10/24 - for autralia 

etc. etc.

note* it will work in PowerBI Service, if you refreshed on your desktop it will give incorrect value since you add 8 hours.

Desktop : now () = local time
Service : now () = UTC time

 

[Mooihoek]

Get Date = NOW() is not known in the latest version of the Power BI client

[rommel20]

Time will not refreshed automatically without refreshing the dataset, else you can use direct query and enable Last Refreshed in dashboard tile.

[melina]

i already refreshed my dataset, but in my report, the time not show current time. Supposedly for cuurent time it will show 10.24 a.m