Show next 5 years data.

[amunshi]

Hi.

I want to display next 5 years data according to the slicer selection.
For example, if I select 2016 in the slicer then my matrix should show Total Sales for next 5 years viz(2017,2018,2019,2020,2021).
Any help would be appreciated.

Regards,

Ashlesha

[v-henryk-mstf · Accepted solution]

Hi @amunshi ,

According to your description, I did the following tests:

M_ =
VAR a =
    YEAR ( SELECTEDVALUE ( 'Table'[Date] ) )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            YEAR ( 'Table'[Date] ) > a
                && YEAR ( 'Table'[Date] ) < a + 5
        )
    )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

HI @amunshi 

You need to use a measure and date table; I don't know how your data looks like, but try something like this:

measure=
Var _SD=selectedvalue[Date column form date table in the slicer])
Var _SD5 = _SD+5
return
calculate(sum([Sales],filter(table, [date]>=_SD&&[date]<=_SD5))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!