Forum Discussion
Solved
Display current date and time
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 cor...
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
