Forum Discussion
Dynamic calculation for difference between two non-date matrix columns
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!
Thanks
Hi,
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 We cannot subtract based on order of the selection.