cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
L_Oram
New Member

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 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? 

1 ACCEPTED SOLUTION
devanshi
Helper V
Helper V

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

 

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

View solution in original post

2 REPLIES 2
devanshi
Helper V
Helper V

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

 

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

tamerj1
Super User
Super User

Hi @L_Oram 
Better if you present a sample dummy data.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors