Calculate the difference between two columns in a multi level matrix

Question

&nbsp;Here is the source data:&nbsp;&nbsp;Here are the potential values:&nbsp;&nbsp;Here is the output matrix in Power BI:&nbsp;Here are the Power BI Visualizations and Fields:&nbsp;&nbsp;I would like to create a measure to calculate the difference between Version 1 and 2 like this (Columns E and H):&nbsp;&nbsp;Note: This report will change version and quarter filters so the Delta needs to recalcultate.&nbsp; Thanks for any help!

amitchandak · Answer

Create three measure Sales V1, Sales v2 and Diff and use them?&nbsp;V1 = calculate(sum(sales), version ="V1")
V2 = calculate(sum(sales), version ="V2")
Diff = V2-V1Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739 https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601&nbsp;

anonymous · Answer

This works great if I only have V1 and V2.&nbsp; &nbsp;However, I need it dynamic.&nbsp; What if I have 10 versions and need to compare sales in V2 vs V5?&nbsp; This could end up requiring 20+ calculation columns, any idea how to get around this?