Variance Between Columns help

[paguy215]

I've gone through a few forums and can't find any solution that works.   Basically I have a matrix and I'm trying to show the difference between two columns...in this case the Delta column in relation to 2021 vs 2022

	2022	2021	Delta
Sales	$2,000	$2,500	$500
Units	75	100	25
Average	$26.67	$25.00	($2)

Everything I've tried has not worked.   Sales and Units are two different measures (columns in the table) while Average is just a calculated measure.   I would love to be able to find a way to make this work with multiple measures in one view.  In addition, I would love to have it be dynamic based on a date selection slicer (IE a MTD or a custom date range).  

Any help is very much appreciated..thanks!

[Wilson_]

Hello paguy215,

Power BI is not Excel.

I believe you're making what is a very understandable mistake. A table/matrix looks like a spreadsheet. However, you cannot essentially reference individual cells of a table/matrix. (To further drive home this point, the subtotals and totals in a matrix are also not a summing up of the cells above or to the right!)

What you can do is write, in this example, a measure for sales in 2022, a measure for sales in 2021 and a measure for the variance between those two measures.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)