Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
All calculated column Year
and do the matrix as per below screenshot,
All calculated column Year
and do the matrix as per below screenshot,
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |