cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
melina Member
Member

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 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!

1 ACCEPTED SOLUTION

Accepted Solutions
rommel20 Regular Visitor
Regular Visitor

Re: Display current date and 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

 

 time.JPG

 

View solution in original post

4 REPLIES 4
rommel20 Regular Visitor
Regular Visitor

Re: Display current date and time

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

melina Member
Member

Re: Display current date and time

Capture.PNG

 

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

rommel20 Regular Visitor
Regular Visitor

Re: Display current date and 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

 

 time.JPG

 

View solution in original post

Highlighted
Mooihoek Regular Visitor
Regular Visitor

Re: Display current date and time

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 344 members 3,714 guests
Please welcome our newest community members: