Showing logged in user Date time with Type of timezone it belongs to

[Surekha]

Hi,

In the Report, i need to show the logged in users current Datetime and type of timezone it is showing. Using DAX Now() i will get the current date and time however i am not getting whether it is EST,PST or CET timezone. I need to add timezone also to the timestamp. Please suggest if anything related to Power Query or DAX function this can be achieved. Thanks in Advance.

[v-xinruzhu-msft]

Hi @Surekha 

You can use DateTimeZone.From() in power query/

e.g:= DateTimeZone.From(DateTimeZone.LocalNow())

Output:

You can refer to the following link:

DateTimeZone.From - PowerQuery M | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Surekha]

Thanks for your response. i have tried the one that you provided i getting like this

18/01/2022 10.33:57 AM +00:00 . What i need is 18/01/2022 10.33:57 AM GMT . Is that possible to show GMT/EST/CET like this. It will vary if user runs the report from US then as per his timezone it should show. 

[FreemanZ]

@Surekha 

yes, check this

https://learn.microsoft.com/en-gb/powerquery-m/datetime-addzone

https://community.powerbi.com/t5/Desktop/Convert-utc-to-local-time-zone-using-Power-Query/td-p/45533

[Surekha]

Thanks for your response. What i need is 18/01/2022 10.33:57 AM GMT . Is that possible to show GMT/EST/CET like this. It will vary if user runs the report from US then as per his timezone it should show. if i run from Indian it show India timings and with IST at the end of the date