Forum Discussion
Adjust a cross-filter
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