I have problem, but I can't solve it. I made matrix from table with values for places each year. I get Total in column to right but I need difference between column nr. 2 and 10 and ratio in next column. I don't find solution for that.
My example in Matrix table
Place 2011 2012...........2019 Total(but I need difference)
You can use measure formula with if statement to check current row contents level and apply specific calculation formula if they are on total level and use normal summary formula on other levels. (replace original value field)
You shoould have a Calendar Table and an active relationship between the Date column of your Data Table to the Date column of the Calnedar Table. In the Calendar Table, write this calculated column formula to extract the year
Year = Year(Calendar[Date])
To your visual, drag the Year field from the Calendar Table.