Matrix/Pivot with sum per year

[Anonymous]

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 

[amitchandak · Accepted solution]

@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_R · Accepted solution]

All calculated column Year 

and do the matrix as per below screenshot,

[amitchandak · Accepted solution]

@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.