Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |