Forum Discussion

30rakesh's avatar
30rakesh
Regular Visitor
10 years ago

Get Current UTC datetime

Hi,

 

Can anyone please suggest me on how to get the current datetime in UTC. I used function Now() but it is returning the current system local time.

 

Thanks

Rakesh

Need Help

3 Replies

  • SabineOussi's avatar
    SabineOussi
    Skilled Sharer
    10 years ago

    Hi rakesh,

     

    I am not aware of a way to do it in DAX, but you can do it in M by going to edit queries and adding a custom column with the formula: DateTimeZone.UtcNow()

     

    If you still want do it in DAX and use it as a measure, you can get your current timezone by using Now() and adding or substrating hours in order to get UTC time.

     

    Hope this helps!

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      To subtract 1 hour from NOW, you can use a formula like:

       

      Column = NOW() - 0.04166666666666667

      For 2 hours:

      Column = NOW() - 0.04166666666666667*2

      etc.

       

       

  • elliotdixon's avatar
    elliotdixon
    Responsive Resident
    9 years ago

    Hi 30rakesh I use a slightly different formula to Greg_Deckler

     

    Find your timezone e.g. mine is New Zealand +13hours for summer time.

    and use code

     

    Date NZTimeZone_NowDateTime = NOW()+(13/24)

    unfortunatley I have to remember to change this back after daylight savings time.