Forum Discussion
Excluding Blanks in a Column
dineshj ,
I would have to see your data, however, you can implement ISBLANK check first and modify the blanks into something else that you can then filter out.SWITCH( TRUE(), ISBLANK(Source1[Final Due 1]), "No value", Source1[Final Due 1] = 0, "On Time", Source1[Final Due 1] < 0, "Early", "Late")
Hi, dineshj
if you use multiple conditions, don't use IF but SWITCH:
SWITCH(
TRUE(),
Source1[Final Due 1] = 0, "On Time",
Source1[Final Due 1] < 0, "Early",
"Late")
and then in the Visulasiation panel and its filter, just Select all except "Blank".
Something like this:
Hi vojtechsima , I used the Switch function but still getting the same results. The blanks are still showing up as "On time". I looked in the transform data query and see that the original column has blanks as null.
I am not sure why it's still taking the blanks as 0s.
dineshj ,
I would have to see your data, however, you can implement ISBLANK check first and modify the blanks into something else that you can then filter out.SWITCH( TRUE(), ISBLANK(Source1[Final Due 1]), "No value", Source1[Final Due 1] = 0, "On Time", Source1[Final Due 1] < 0, "Early", "Late")