Forum Discussion
Matrix/Pivot with sum per year
I have this table : and I would like to sum up every item per year so it would look like this I tried with matrix and extra measure but I am just geeting empty cells in matrix. P...
Anonymous , You can have year column of date table with year column or use [Date].year
Year = Year([Date])
You can use that in the column, item on row, and the sum of price on values in a matrix.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
All calculated column Year
and do the matrix as per below screenshot,
All calculated column Year
and do the matrix as per below screenshot,