Forum Discussion
Adding a Time Zone Slicer [DAX]
Have you created OffsetTime as a measure or a calculated column? Calculated columns get calcuated once and do not change in response to filter selections. Measures are calculated dynamically and do change in response to changes in filters. You issue suggests that maybe you've created this as a column.
OffsetTime is indeed a calculated column. I need this function to offset the incoming datetime data by the selected number of hours, therefore the output needs to be calculated on a per-row basis.
Additionally, I have created IntOffset, which is a measure that returns a single integer. I tried creating it both as a var (seen above), and also as its own measure to try to make this work.
Hey Did you got any solution on this? I am facing the same issue.. will you please let me know
