Forum Discussion

AndySmith's avatar
AndySmith
Icon for Helper III rankHelper III
3 years ago
Solved

Today() Function - UTC Offset

Hi  Apologies in advance - as I have seen several posts on this already - but I am just struggling to make sense of any of it! I have a measure which uses the 'today()' function to work out the pre...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi AndySmith ,

    Please try to use NOW().

    Column = NOW()+TIME(10,0,0)

    The column=today()+time(10,0,0) represents 2023/1/19 10:00:00.

     

    Best Regards
    Community Support Team _ Polly

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi AndySmith ,

"the time difference between the Power BI service UTC and my local time".

Below are 3 possible methods to get around this issue

  • One method to get the correct DateTime is by connecting to a web service to return the local time of whatever region you need. 

  • Probably the easiest method to use is by simply adding or subtracting the difference of your time zone and UTC time from the DAX NOW() function.

  • Power Query has inbuilt functions to deal with this issue, namely the DateTimeZone functions. 

More details: Power BI Date and Time in Desktop vs Service – Bond Consulting Services

 

Best Regards
Community Support Team _ Polly

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