Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Convert to local time - DAX

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 s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.