Forum Discussion
Variance Between Columns help
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 relatio...
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?)