Filter a blank from a column

[Anonymous]

Hi All,

I am trying to filter a column of dates from the blank rows.

This is my DAX but it doesnt work. 

ColumnName =

VAR _test =

Contracten[Verwachte datum contract km bereikt] <> BLANK()

RETURN

IF (

DATEDIFF ( UTCTODAY (); _test; MONTH ) <= 4;

"EindContractKM ";

BLANK ()

)

Thank you

[edhans]

Try ISBLANK() instead of <> BLANK(). 

VAR _test =
ISBLANK(Contracten[Verwachte datum contract km bereikt])

Also, are you sure it is blank? You might want to read this article on blanks, nulls, empty (""), etc. 

EDIT: I didn't notice how you were using the variable later. I think @az38 has nailed the issue.

[Anonymous]

Hi @edhans, I tried this already and didnt get the right result

[az38]

Hi @Anonymous 

your _test variable returns BOOLEAN what that cannot be used as second argument in DATEDIFF()

what value do you need there?

whats your desired result for row with Contracten[Verwachte datum contract km bereikt] <> BLANK() ?

[Anonymous]

HI @az38 I would try the value (date) of the rows except the blank rows of  Contracten[Verwachte datum contract km bereikt] 

Regards,
Ezz 

[az38]

@Anonymous 

maybe it will be enough to try a simple version of yours statement? Like

ColumnName =
IF( 
Contracten[Verwachte datum contract km bereikt] <> BLANK() 
&& DATEDIFF ( UTCTODAY (); Contracten[Verwachte datum contract km bereikt]; MONTH ) <= 4;
"EindContractKM ";
BLANK ()
)

[Anonymous]

@az38  yes this works, Thank a lot 🙂

Regards,

Ezz