Forum Discussion

CowboyTony's avatar
CowboyTony
Regular Visitor
8 years ago
Solved

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

 

  • RahulYadav's avatar
    RahulYadav
    8 years ago

    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

  • RahulYadav's avatar
    RahulYadav
    Resolver II
    8 years ago

    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