Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |