Forum Discussion
Solved
Last year/month value
Hi I have a problem with calculations of different dates, I have a matrix by product, and the month dimension pivoted, in one column I need to add the value of the current year and in another the las...
calculate (sum (table [value]); filters (ALL(Table[year]), table [year] = selectedvalue(Table[year]) - 1))
