Forum Discussion
Solved
How to write If function not to choose null values
I created a New column using this
Date Filter For DueDate = IF( HD_Ticket[DUE_DATE] < TODAY(), 1,0) but it was returned 1 to the null values too.
I don't want null values.
Hi Sowjanya_09
How about something like this:
DueDate = IF( HD_Ticket[DUE_DATE] < TODAY() && HD_Ticket[DUE_DATE] <> BLANK() , 1,0)
Let me know if this helps 🙂/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
1 Reply
Hi Sowjanya_09
How about something like this:
DueDate = IF( HD_Ticket[DUE_DATE] < TODAY() && HD_Ticket[DUE_DATE] <> BLANK() , 1,0)
Let me know if this helps 🙂/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/