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.
Please help
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,
2 Replies
- amitchandak
Super User
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.
Singaravelu_RResolver III
All calculated column Year
and do the matrix as per below screenshot,