Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello. I am trying to create a Proof of Concept for a client to demonstrate how they can implement a slicer to shift their time data based on time zone. I know similar questions have been asked and answered, but I still can't reproduce the solutions I have seen.
Here is my current workspace:
I have tried a few different formulas, including:
OffsetTime = var IntOffset = SELECTEDVALUE('TimeZone Offset Dim'[offset], 0) return FORMAT([Date] + DIVIDE(IntOffset,24,0), "General Date")
As my screenshot shows, IntOffset correctly shows the integer of hours I want to shift, but the OffsetTime continues to show the same value as the original Date value.
Does anyone have advice for this?
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
User | Count |
---|---|
123 | |
111 | |
99 | |
60 | |
60 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |