Here is the source data:
Columns: [Version, Unit, Customer, Quarter, Sales)
Here are the potential values:
*Note: We may have 10 different versions and 20+ different quarter year combinations.
Here is the output matrix in Power BI:
*Users can select a Version and two quarters to compare.
Here are the Power BI Visualizations and Fields:
I would like to create a measure to calculate the difference between Version 1 and 2 like this (Columns E and H):
I'm able to create a new table with columns of sales for Version 1,2,3 then calculate the difference. The problem is I need the version and quarter to be dynamic. Any ideas how to do this in Power BI?