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(Slakteegen...
  • 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 

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 

  • msbiuser1's avatar
    msbiuser1
    Icon for Advocate I rankAdvocate I
    3 years ago

    Seems to be correct. I was about to write the same logic. 

    Marit  Kindly mark as solution .