Hi learned brethren,
I have 3 sets of 2 data cards.
One set (High) has a card for sum of 2019 values, and the other is sum of 2018 (or LY) values. This latter one uses SAMEPERIODLASTYEAR function.
Then 2 more sets (Med) and (Low) …. again each of these sets contain 2019/2018 (or LY) values.
What I’m trying to achieve is to use a date slicer, that when changed, also changes each set of high/med/low data cards. eg. changing the date slicer will change the values for each category of 2019 and 2018 (LY) cards.
Hope this makes sense.