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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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