cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Narender Member
Member

Re: Last Five year collection

Hi ,

 

Please see the below screen shot.

 

1.jpg

You can see it is showing year 2015,2016,2017 data. But i want to see only last 2 year data means 2017 and 2018.

Actually i dont have 2018 data thats why it is showing upto 2017 year data not 2018 data.   

 

So how can we show last 2 year data not all year data?

 

 

Narender

 

 

Floriankx Established Member
Established Member

Re: Last Five year collection

If you want to exclude years from your graph you could add a sclicer for Years

Narender Member
Member

Re: Last Five year collection

Thank you.

 

But I dont want any hard code becuse i want to automatically change year according to last year.

 

 

 

Narender

Floriankx Established Member
Established Member

Re: Last Five year collection

Hello,

 

given the following table of anual amounts:

YearAmount
2014100
2015125
2016133
2017150
2018

175

 

Would be your expected result?

Narender Member
Member

Re: Last Five year collection

Yes.

But when 2019 year come then it will show from 2015 to 2019.

 

 

Thanks.

 

Narender

Floriankx Established Member
Established Member

Re: Last Five year collection

So you don't want to sum up the years?

 

If you want to exclude values older than 5 years you could try:

 

Last5YearsOnly=
IF(MAX(Date[Years]>=YEARS(TODAY())-5,[TotalSum],BLANK())

 So you could simply exclude all values older than actual year -5.