Forum Discussion

melina's avatar
melina
Helper IV
9 years ago
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...
Need Help
  • rommel20's avatar
    rommel20
    9 years ago

    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

     

     

     

rommel20's avatar
rommel20
Resolver I
9 years ago

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's avatar
    Mooihoek
    Helper II
    8 years ago

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