Calculating difference from previous period

[akowalski]

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!

[Floriankx · Accepted solution]

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.

[akowalski]

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?

[Floriankx]

Hello,

It is hard to tell with knowing so little about your Table structure?

Can you provide some dummy data?