Forum Discussion

L_Oram's avatar
L_Oram
Regular Visitor
3 years ago
Solved

DAX Overdue column

I'm new to DAX and was wondering if I could get some help.   I want to create a new column that would show if a task is overdue.    First I need to check the 'Current Status' column and see if it...
  • devanshi's avatar
    3 years ago

    status = IF([CurrentStatus]="Not started" || [CurrentStatus]="In progress","Open","Close")

     

    duedate = IF([DueDate]<TODAY(),"Overdue","Not overdue")