Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Last Refresh of Data

For months I have been successfully using the following DAX statement to ashow a Last Refresh Date/Time on my dashboards.  This was working with successfully, however since scheduling refrsesh using ...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Not to be picky, but that's Power Query "M" language, not DAX. You should be able to use:

     

    DateTime.Time(DateTime.LocalNow()) + #duration(0, -5, 0, 0)
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    There is a known gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC.

     

    There is a workaround to display time in your current time zone. You can use following power query in the Query Editor if your time zone is 5 hours behind Coordinated Universal Time (UTC−05:00). :smileyhappy:

    = DateTime.Time(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 )) & DateTime.Date(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 ))

     

    Regards

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Not to be picky, but that's Power Query "M" language, not DAX. You should be able to use:

 

DateTime.Time(DateTime.LocalNow()) + #duration(0, -5, 0, 0)
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks for the clarification.

     

    Below is a representation of the output.  I was expectiing 7/13/2017 3:52:50 PM

     

    Thoughts?

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      9 years ago

      Yes, see formula above. Essentially, it is adding/subtracting hours from the date/time value returned from LocalNow to account for the time zone shift. In your case it looks like you would want to use +5?

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

       

      There is a known gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC.

       

      There is a workaround to display time in your current time zone. You can use following power query in the Query Editor if your time zone is 5 hours behind Coordinated Universal Time (UTC−05:00). :smileyhappy:

      = DateTime.Time(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 )) & DateTime.Date(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 ))

       

      Regards