Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
akowalski
Frequent Visitor

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!

1 ACCEPTED SOLUTION
Floriankx
Solution Sage
Solution Sage

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.

 

View solution in original post

3 REPLIES 3
Floriankx
Solution Sage
Solution Sage

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?

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.