Forum Discussion
Dynamic calculation for difference between two non-date matrix columns
I have a matrix with region related fields as the column headers. A slicer for this matrix contains about 40 regional related fields available to populate the matrix columns. I have instructions on...
Ashish_Mathur,
I've been using the PBI file that you've shared. Using the existing solution the Difference always comes out to be positive, is there a way to determine which Region was selected first and second so that the difference could be calculated using Region1Value - Region2Value?
I want the expected result to have the - sign for negative values(marked in red):
| Part number/List Price | Region X | Region Y | Difference (negative value where Region X > Region Y) |
| ABC123 | 100.00 | 100.00 | 0 |
| ABC456 | 50.00 | 50.00 | |
| ABC789 | 25.00 | 30.00 | 5.00 |
| DEF123 | 600.00 | 500.00 | -100.00 |
| DEF456 | 60.00 | -60.00 |
We cannot subtract based on order of the selection.