IF Dax

[colourfullife]

Hi All,

I need a Help!

I want to make a new column of status. What i want to make is Status column.

There are 4 categories that i want to have as conditions below.

Condition :

1. Delivered on time : Comparing Actual Delivery date with Target date, it is on time then,

2. Delivered Late : Comapring Actual Delivery with Target Date, it's delivered late then,

3. Delayed : No Delivery date and also passed Target Date then,

4. To be delivered : Target date is not yet come then...

Actual Delivery Date	ROS TARGET	Status
null	17/09/2019	Delayed
null	06/05/2020	to be delivered
null	31/07/2019	Delayed
null	31/07/2019	Delayed
null	31/07/2019	Delayed
06/08/2019	01/05/2019	Delivered Late
06/08/2019	01/05/2019	Delivered Late
null	31/07/2019	Delayed
null	01/05/2019	Delayed
06/08/2019	01/05/2019	Delivered Late
null	31/07/2019	Delayed
null	09/05/2019	Delayed
null	31/07/2019	Delayed
null	31/07/2019	Delayed
23/07/2019	16/05/2019	Delivered Late
23/07/2019	16/05/2019	Delivered Late
03/06/2019	16/05/2019	Delivered Late
03/06/2019	16/05/2019	Delivered Late
18/01/2019	20/09/2019	Delivered on time
18/01/2019	20/09/2019	Delivered on time
18/01/2019	20/09/2019	Delivered on time
18/01/2019	20/09/2019	Delivered on time
18/01/2019	20/09/2019	Delivered on time
18/01/2019	20/09/2019	Delivered on time
18/01/2019	20/09/2019	Delivered on time

Is there any idea?

Thank you,

CL

[az38 · Accepted solution]

Hi @colourfullife 

try this calculated column

STATUS = if(and(NOT(ISBLANK(Table1[Actual Delivery Date]));Table1[Actual Delivery Date]<=Table1[ROS TARGET]);"Delivered on time";if(not(isblank(Table1[Actual Delivery Date]));"Delivered Late";if(and(isblank(Table1[Actual Delivery Date]);NOW()>Table1[ROS TARGET]);"Delayed";"To be delivered")))