cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CowboyTony Frequent Visitor
Frequent Visitor

IF DAX Calculated Column

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 DateClosed?Malfunction End dateMax Labour DatePseudo Complete date
1/1/2018Closed1/1/2018 6/7/2017 0:00
1/2/2018Closed 1/2/20186/7/2017 0:00
1/3/2018Closed  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 dateMax Labour DatePseudo Complete date

 if record is "open" leave column blank.

 

Help me out here guys, under pressure with this :-(

 

Regards

Cowboy Tony

 

1 ACCEPTED SOLUTION

Accepted Solutions
RahulYadav Regular Visitor
Regular Visitor

Re: IF DAX Calculated Column

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

2 REPLIES 2
RahulYadav Regular Visitor
Regular Visitor

Re: IF DAX Calculated Column

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 Frequent Visitor
Frequent Visitor

Re: IF DAX Calculated Column

Works perectly, really appreciate it Smiley Happy