Problem with ISNULL DAX code

[jonclay]

Hi everyone
I'm very new to PowerBI, so apologies if this is a day 1 rookie error!

What I'm trying to achieve is to create a column called Total Received & Banked (one-off) which is an addition of columns 

sic_transactions[DC1 Total Inc GA, sic_transactions[DC1 Total Inc GA and sic_transactions[DC1 Total Inc GA if the column called 

sic_transactions[sic_pledges.sic_pledgedate is blank.

I've included my DAX code in the attached image. What is actually happening is the reverse of what I'd like to happen. The new Total Received & Banked (one off) column is only calculating if the sic_transactions[sic_pledges.sic_pledgedate field is NOT blank.

Could anyone please tell me what I'm doing wrong?

Many thanks

Jon

[AlexisOlson · Accepted solution]

That's exactly what you told it to do. Abbreviating names, your DAX looks like this:

IF ( ISBLANK ( sic[Date] ), BLANK (), sic[DC1] + sic[DC2] + sic[DC3] )

This says that if [Date] is blank, return a blank, otherwise do the sum. If you want the opposite, just remove "BLANK()" or put it as the 3rd argument instead of the 2nd.

[jonclay]

Hi Alexis

Many thanks, that works great now. I knew that it would be something silly that I'd done!

Best wishes,

Jon