Adjust a cross-filter

[PowerWhy]

Hi,

If I have a slicer of fiscal years and a table of data below, is there a way I can adjust the cross filter so that the table shows the "next year" to that selected in the slicer? (i.e. the sliced year + 1)

Thank you,

CW

[amitchandak]

@PowerWhy , You need to have separate date/year table joined

Next Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])+1))

but this will not show the year on the axis , data will of the next year against the selected year; if you need the year on the axis. You need independent table for slicer

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Year])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Year] =_max+1))

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA