Forum Discussion
DAX: New Column - Add Hours to Datetime Timestamp /w Dynamic Measure (Time Zone Offset)
Hello, Using DAX, I am trying to add a column to a table that, using a dyamic measure, adds hours to the existing timestamp. Each record in my existing data table contains a timestamp. Th...
You cannot do that. Calculated columns are calculated 1 time, at refresh. Never again until the next refresh. They are not like columns in an Excel table that update with each worksheet calc.
You would need to use a visual that returned the timestamp you want as a measure and add your TZ offset there to visually represent the updated timestamp.
Ah, that's frustrating, but it makes sense. Thanks for the reply and your help!