Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
Get Date = NOW() is not known in the latest version of the Power BI client
Time will not refreshed automatically without refreshing the dataset, else you can use direct query and enable Last Refreshed in dashboard tile.
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |