topic Re: DAX Overdue column in DAX Commands and Tips

DAX Overdue column

L_Oram — Wed, 31 May 2023 10:39:27 GMT

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 contains 'Not started' or 'In progress' to see if the task is still open (closed & completed are the other options in the column). Then I need to check the 'Due Date' column and compare with today's date to see if it's overdue.

What is the easiest way to write this in DAX?

Re: DAX Overdue column

tamerj1 — Wed, 31 May 2023 10:51:19 GMT

Hi L_Oram
Better if you present a sample dummy data.

Re: DAX Overdue column

devanshi — Wed, 31 May 2023 11:20:00 GMT

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

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