Dear Specialists,
I have a slicer with time frames (Yesterday, Fiscal Year, Last Quarter).
It's actually a bridge table that filters the date table.
Then I have a matrix visual.
Rows shows some dimensions data (countries eg)
Colums are the selected values (like yesterday, ytd etc)
value is for example sales amount
Now I would like to have two measures or even more, that always shows the var% of the first and second (third and fourth, fifth and sixth..) selected value.
Means:
I select YTD and Prior YTD in the slicer and in this first measure I get the variance between this.
I select current quarter, last quarter as number 2 and 3 and then I will get the variance of this in my measure2.
Actually I would like to reference certain values in selectedvalue() function.
Or anything similar.
Any idea? Or any other approach to get the var% in a variable way?
Thank you very much
