Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Here's a start.  Download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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! 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.  If my reply helped, please mark it as Answer.