Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

calculating the difference between two lines

  Hello I have a concern please. I would like to have the result of this table in dax, that is to say income-expenditure knowing that I have created a group where other are the income and othe...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    Hi Anonymous ，

    Because in the measure, when I use the column, it will return to the value of the column itself to me, as follows, I made the relevant adjustments to the data and got still their difference, in addition to the field total can be adjusted to another name by itself（the max in measure not get the max value ,and it get the base value ,it equare you create a new column that is new column=value):

     

     

    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
3 years ago

Hi  Anonymous ,

Create measure like the below:

TEST = 
IF (
    HASONEVALUE ( 'Table'[Type1] ),
    MAX ( 'Table'[value] ),
    CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "A" ) )
        - CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "B" ) )
)

 

 

Best Regards

Lucien

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Please what is 'table'[value]

    • v-luwang-msft's avatar
      v-luwang-msft
      Community Support
      3 years ago

      Hi Anonymous ,

      The data in the table used to become the values in the matrix you created, are as follows:

       

       

      Best Regards

      Lucien

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        And as it is several columns which are on value how to do it please? In your case it's A1 and A2 how to put them in MAX