Forum Discussion

Marit's avatar
Marit
Icon for Helper II rankHelper II
3 years ago
Solved

Subtract two columns based on conditions

Hi! 

 

I try to calculate a new column, where I want to subtract two columns from different tables if one of the columns is not blank. I used this DAX: 

DB2perareal = CALCULATE(AVERAGE(Slakteegenskaper[DB1perareal]) - AVERAGE(PriskonstantDB2[Priskonstant]), NOT(ISBLANK(Slakteegenskaper[DB1perareal])))
 
However, if Slakteegenskaper[DB1perareal] is blank, this formula gives 0 - PriskonstantDB2[Priskonstant]). 
 
Could anyone help me out with this?
 
Regards Marit
  • saravanan_p's avatar
    saravanan_p
    3 years ago

    So in my understanding, you dont want to substact when that column has blank right.
    In that case, you rewrite as folows:

    if(not(blank(col1)), col1- col2, "Pass your else command")

    Pass your else command when blank value appears.

     

    Hope this solves the problem and kindly mark this as solution 

3 Replies

  • saravanan_p's avatar
    saravanan_p
    Icon for Resolver III rankResolver III
    3 years ago

    So in my understanding, you dont want to substact when that column has blank right.
    In that case, you rewrite as folows:

    if(not(blank(col1)), col1- col2, "Pass your else command")

    Pass your else command when blank value appears.

     

    Hope this solves the problem and kindly mark this as solution