cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akowalski Frequent Visitor
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

Accepted Solutions
Floriankx Established Member
Established Member

Re: 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.

 

View solution in original post

3 REPLIES 3
Floriankx Established Member
Established Member

Re: 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.

 

View solution in original post

akowalski Frequent Visitor
Frequent Visitor

Re: Calculating difference from previous period

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?

Highlighted
Floriankx Established Member
Established Member

Re: Calculating difference from previous period

Hello,

 

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

 

Can you provide some dummy data?

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 104 members 1,343 guests
Please welcome our newest community members: