I currently have a blended measure that works with a valid from and valid to date:
Currently in my graph it will SUM both of them and show that as measure:
I want the limit measure to use the valid from and valid to date, so when I would select a date in the 1-1-2018 - 16-2-2018 range for abcd I want to see 500, but when I select a date after 17-2-2018 I want to see the 100.
Currently I just extract the most actual limits using a filter on the data source:
DATE([validto]) = #1-1-9999#
But it would be nice to implement something as described above, any ideas?
Any suggestions? Have not been able to get it working
I do have a dim date so I could maybe work with this