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...
  • 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

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

  • CowboyTony's avatar
    CowboyTony
    Regular Visitor
    8 years ago

    Works perectly, really appreciate it :)