Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Marit
Helper II
Helper II

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
1 ACCEPTED SOLUTION
saravanan_p
Resolver III
Resolver III

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 

View solution in original post

3 REPLIES 3
saravanan_p
Resolver III
Resolver III

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 Thanks

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

@Marit  Kindly mark as solution . 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors