Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

YoY % Change Matrix Total Calc

Hello I created a YoY measure that outputs blank values if the YoY divison formula outputs a -1 or 0. This works fine for graphs, but when I use this measure in a matrix, the total is very off. This ...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could use IF() and ISINSCOPE() funcitions to change the last value.

    Here is my test file for your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You could use IF() and ISINSCOPE() funcitions to change the last value.

Here is my test file for your reference.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

could anybody just write the applied measure or explain the measure. I do not understand why we need a primary key here index to refer to in column1, do we not have to reference to date and the the selected measure as well as year to date measure applied to above problem? So like measure = a= max (date(date)

                                       return IF(ISINSCOPE(date(date, calculate (selectedmeasure), filter (date(date), selectedmetrics))?