Forum Discussion
Calculating difference from previous period
Hello,
How can i calculate difference from previous period, when 2 years are selected from slicer. It can be 2017, 2018 but also 2015 and 2018.
I have a list of countries on a column/line chart, every one with values from selected 2 years. I tried DateAdd funcion, but i cannot put there a variable showing a difference in years.
If you know better way of showing actual value and a difference from previous period for many countries on a single chart i would love to know it!
Thank you!
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.
3 Replies
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?
