Convert to local time - DAX

[Anonymous]

Hi all, I have 2 tables

1.) GMT table

2.) Master table

I would like to convert the "Time" of the table to the local time. However, PowerQuery seems not to be a feasible soluction since it is not supported by direct query, hence, Im looking for a simple way from DAX.

Thanks so much if there is an efficient way to get the Desired local time value.

Market	GMT Offset
Hong Kong	8
Korea	9
Australia	10
Taiwan	8

Market	Report Time(GMT+0)	Desired local time
Australia	2/28/2022 8:05	2/28/2022 18:05
Taiwan	2/28/2022 8:05	2/28/2022 16:05
Taiwan	2/28/2022 8:05	2/28/2022 16:05
Australia	2/28/2022 8:05	2/28/2022 18:05
Korea	2/28/2022 8:05	2/28/2022 17:05
Hong Kong	2/28/2022 8:05	2/28/2022 16:05

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try:

Column = [Report Time(GMT+0)]+LOOKUPVALUE(Table1[GMT Offset],[Market],[Market])/24

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

[mh2587]

https://cloudbi.com.au/converting-utc-to-local-datetime-in-power-bi/