Forum Discussion
Difference between Column Values in the Matrix Visual
Hi mohammedkhan ,
If you drag-and-dropped those columns onto your table, then Power BI automatically creates an implicit measures in the background that likely looks like SUM(Table[2015]) and SUM(Table[2016]). To calculate the difference, create a measure to subtract the second from the first:
Difference1 = SUM('Table'[2015]) - SUM('Table'[2016])
If you need to determine the size of the data corresponding to the year, the larger data is subtracted from the smaller：
Difference1 =
var test1= SUM('Table'[2015])
var test2= SUM('Table'[2016])
var test3=IF(test1>test2,test1-test2,test2-test1)
return test3
Wish it is helpful for you!
Best Regards
Lucien
mohammedkhan , this kind of custom display , you might not get in matrix. You can diff after every year
With help from a separate year/date table you can get
example measures
This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])
check the hybrid display
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc