Thanks a lot for your help.
Let me tell you what i did, meanwhile i didn’t get any answer to this post:
This is the P&L Statement, the way Sam taught us to do.
I did the first matrix on the left and copy it to the right 2 times and hide the row headers. Now i just have to do another with the differences.
With this “solution” i can pick whatever year i need and month.
Also, i’ve add 3 columns on the dates table, year-0, year-1 and year-2. My main measure for each matrix is filtered by …FILTER( ‘Tab Dates’, ‘Tab Dates’[Year] = ‘Tab Dates’[Year - 0] )). The second will be filtering year-1 and so on.
This solution, instead of doing 7 measures for the subtotals it’s gonna be 21, 7 for each matrix visual.
Also, i’ve never heard about joinning two matrix visuals, as well as the yearoffset, don’t know how it works.
What do you think @Melissa? Should i delete this one and start all over?
Thanks a lot
P.S. Forgot to say that those year boxes above are those columns i’ve create on the date table