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 ，

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