Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to 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.
https://cloudbi.com.au/converting-utc-to-local-datetime-in-power-bi/
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |