The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |