Forum Discussion
Anonymous
6 years agoNot applicable
Filter a blank from a column
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(...
edhans
Community Champion
6 years agoTry 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.
- Anonymous6 years agoNot applicable
Hi edhans, I tried this already and didnt get the right result