Forum Discussion

arothberg's avatar
arothberg
Frequent Visitor
2 years ago

Converting Datetime Field in into Local Date

I have a datetime field on a model (stored in UTC). I would like to work with just the date portion, but converted to a specific timezone. I.e. I can't just format the date, I need to do a conversion first. How would I go about doing that? I tried creating a custom column but am not seeing the relevant datetime function:

 

3 Replies

    • arothberg's avatar
      arothberg
      Frequent Visitor

      Version: 2.126.1261.0 64-bit (February 2024)

       

      Why does my Column editor look different though?

      Looks like DAX vs Power Query.