IF DAX Calculated Column

[CowboyTony]

Hey Guys,

I dont seem to be getting the right behaviour with the folowing dax statement in a calculated column:

WO Completion Date =

if('Work Orders'[Closed?]="Closed",'Work Orders'[Malfunction End Date],

if('Work Orders'[Malfunction End Date]=blank(),'Work Orders'[Max Labour Date],

if('Work Orders'[Max Labour Date]=blank(),'Work Orders'[Pseudo Complete date],

blank())))

WO Completion Date	Closed?	Malfunction End date	Max Labour Date	Pseudo Complete date
1/1/2018	Closed	1/1/2018		6/7/2017 0:00
1/2/2018	Closed		1/2/2018	6/7/2017 0:00
1/3/2018	Closed			1/3/2018 0:00
	Open			6/7/2017 0:00

I want to create the above result set in calculate column "WO Completion Date" where:

if the record has the status of "closed" then populate dates from the following columns in this order of preference

Malfunction End date

Max Labour Date

Pseudo Complete date

 if record is "open" leave column blank.

Help me out here guys, under pressure with this 😞

Regards

Cowboy Tony

[RahulYadav · Accepted solution]

Hi @CowboyTony,

Below Dax formula should solve you problem.

WO Completion Date = if('Work Orders'[Closed?]="Open",BLANK(),
    if('Work Orders'[Closed?]="Closed",
        if(ISBLANK('Work Orders'[Malfunction End Date])=FALSE(),'Work Orders'[Malfunction End Date],
            if(ISBLANK('Work Orders'[Max Labour Date])=FALSE(),'Work Orders'[Max Labour Date],
                if(ISBLANK('Work Orders'[Pseudo Complete date])=FALSE(),'Work Orders'[Pseudo Complete date])))))

Thanks,

Rahul

[CowboyTony]

Works perectly, really appreciate it 🙂