Dax command that returns time based on logged-in customer timezone, not server timezone (UTC)

[h4tt3n]

Hello everyone,

I am having trouble solving a challenge that I thought must be very simple: To offset timestamps in my report so all times are shown in the customers local timezone, ie. the timezone of the machine on which he/she is viewing my report, and not in the timezone used by the server, ie. UTC.

However useful this function might be to a lot of people, apparently it doesn't exist?

If you have solved this issue, please let me know how you did it.

Cheers & thanks in advance, Mike

[edejes2]

Hello @h4tt3n , 

Try this meassure

Time = NOW()+(12/24)

I hope this is what you're looking for. 

Regards!

ED