Converting Datetime Field in into Local Date

[arothberg]

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:

[lbendlin]

Weird. Seems to work

What desktop version?

[arothberg]

Version: 2.126.1261.0 64-bit (February 2024)

Why does my Column editor look different though?

Looks like DAX vs Power Query.

[lbendlin]

Correct. There is no such function in DAX.