Forum Discussion
Calculating difference from previous period
Hello,
so you want to use slicer to slice for this year and previous year?
Ja can differ using Calculate
MeasureMin= VAR MinSlicedYear=CALCULATE(MIN(DateTable[Year]),ALLSELECTED(DateTable[Year]) RETURN CALCULATE(Sum(Values),FILTER(FactTable,YEAR([DateColumn)=MinSlicedYear))
MeasureMax is analog.
I don't know if this fullfills your purpose exactly but give it a try and let me know.
Best regards.
Hello,
so you want to use slicer to slice for this year and previous year?
Ja can differ using Calculate
MeasureMin= VAR MinSlicedYear=CALCULATE(MIN(DateTable[Year]),ALLSELECTED(DateTable[Year]) RETURN CALCULATE(Sum(Values),FILTER(FactTable,YEAR([DateColumn)=MinSlicedYear))
MeasureMax is analog.
I don't know if this fullfills your purpose exactly but give it a try and let me know.
Best regards.
It is working, but only on the drilled up chart. I have countries and years on shared axis and and when im on the lowest level (both year and country) it is not working. I tried to find a way to do this on the lowest leven in hierarchy? Is is at all possible?
Hello,
It is hard to tell with knowing so little about your Table structure?
Can you provide some dummy data?
