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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.

      • akash9519's avatar
        akash9519
        New Member
        3 years ago

        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

  • SVM75's avatar
    SVM75
    Regular Visitor
    2 years ago

    Hi Ashish, i'm facing the same problem but the file does not seem to be there anymore, any chance that you can send me the file or hint the solution? Thanks, SVM

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      It is an old post.  I do not have that file.  Share som data to work with, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

      • SVM75's avatar
        SVM75
        Regular Visitor
        2 years ago

        Hi Ashish,

         

        I have a list of sale per month per product (example below, in reality, obviosuly several thousands items)

         

        ProductMonthRevenues
        Product AJan.24               32.90
        Product BJan.24               78.61
        Product CJan.24               68.56
        Product AFeb.24               90.98
        Product BFeb.24               65.62
        Product CFeb.24               63.92
        Product AMar.24               71.93
        Product BMar.24               56.19
        Product CMar.24               67.02
        Product AApr.24               87.79
        Product BApr.24               32.28
        Product CApr.24               99.93

         

        and would like to have in PowerBI the option to select two month and have the difference dynamically be calculated, e.g.

         

         

        THanks, SVM