Forum Discussion
Dynamic calculation for difference between two non-date matrix columns
Hello Ashish_Mathur , that worked! It took me some time to figure out that the column subtotals needed to be turned on and relabeled from "Total" to "Difference" but as soon as that was solved it worked great. Thanks again!
You are welcome. If my reply helped, please mark it as Answer.
Hi Ashish_Mathur,
This helped a lot for a similar problem I'm facing.
Do you know how to have the sign (+-) as well like it's given in the original question.
The current solution calculate the MAX value -MIN value so the sign gets lost in the calculation.
I would really appreciate your response and guidance!
ThanksHi,
This is a very old post. Share some data, explain the question and show the expected result.
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
