Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Difference between two columns in matrix visualisation

Hi,   I have in a matrix a row with two columns. Row is company name, and columns are 201806 en 201807 I can make a total (setting a subtotal), but how to make a difference? Example: Company 20...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    Please try to use below formula to replace amount column and drag it to value field. then you will find diff effect apply on total level.

    Diff =
IF (
    ISFILTERED ( Table[Date] ),
    SUM ( Table[Amount] ),
    CALCULATE (
        SUM ( Table[Amount] ),
        VALUES ( Table[Company] ),
        Table[Date] = 201806
    )
        - CALCULATE (
            SUM ( Table[Amount] ),
            VALUES ( Table[Company] ),
            Table[Date] = 201807
        )
)

    Regards,

    Xiaoxin Sheng

fletchuk's avatar
fletchuk
Regular Visitor
7 years ago

Hi,

 

Did you ever find a solution to this? I have exactly the same problem and its driving me insane! I just want to calculate the differences between two columns in a matrix but the solutuon escapes me! It should be easy but everything I've tried - including the soluton you were given - puts a "Diff" column after each of the two existing columns. It's not even calculating properly, it shows the first Diff column as all negatives and the second Diff column as all positives. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Same problem here. Any updates?!