Hi learned brethren,
I have 3 sets of data cards low/med/high categories.
for each set … there are 3 corresponding measures; SUM of values 2018, SUM of values 2019 and the %change.
The SUM for e.g… 2018 uses the DATESBETWEEN function, same for 2019.
What I would like to do is use a date slicer that when selected, for any given dates, changes the SUM for 2018, 2019 and of course the %change.