Forum Discussion
Time stamping a dynamic measure
Community Championrlewis It's difficult for me to grasp what you are doing because it sounds bizarre. Here is how it is supposed to work. You have data:
| 1/1/2021 | blue | 10 |
| 1/1/2021 | red | 20 |
| 1/1/2021 | blue | 30 |
| 2/1/2021 | blue | 5 |
| 2/1/2021 | red | 40 |
You have some measures "Total Value = SUM('Table'[Value])". You put this into a visualization with your Date field as the axis, maybe category (red/blue) as the Legend and your Total Value measure as the Values. Presto, you have measures calculated over a historical range.
I can't even begin to grasp what you are trying to do exactly or why.
Greg_Deckler ok, so this essentially looks like we take the measure value for that day, tie it to the date in another table that we create for this purpose, and we can capture it that way both historically and moving forward.
The reason we are doing what we were doing is complicated and too much to explain, but the logic makes sense.