Solved: Re: Subtract two columns based on conditions

Marit · ‎10-13-2022

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 · ‎10-13-2022

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 · ‎10-13-2022

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 · ‎10-13-2022

msbiuser1 · ‎10-13-2022

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

@Marit Kindly mark as solution .

Subtract two columns based on conditions