Forum Discussion

klb0066's avatar
klb0066
Frequent Visitor
8 years ago

if statement

Creating a splicer with title "Has Due Date?" with True or False checkboxes. Coded an if statement that recognizes if field was left bank then it is false and if the field has a date it is true.   ...
klb0066's avatar
klb0066
Frequent Visitor
8 years ago

It is for work and you are allowed to enter the due date or enter no due date (we are changing this procedure as entering in no due date is pointless now). I want to be able to see what work is overdue that has a due date.

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi klb0066

What do you mean by "you are allowed to enter the due date or enter no due date"?

If your current date is a column which exsits in the table, you can use the following formula

create calculated column, then add this column to a slicer

hasDue = if(ISBLANK(MX_TICKET[TARGETFINISH]),FALSE(),TRUE())

cretae a measure, then add this measure to the Visual Filter

if over due = IF(MAX([TARGETFINISH])>MAX([current date]),1,0)

 

If the current date refer to today, you can use TODAY( ) to replace [current date].

 

Best Regards

Maggie