cancel
Showing results for
Search instead for
Did you mean:
Highlighted
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 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

1 ACCEPTED SOLUTION

Accepted Solutions
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
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

Frequent Visitor

## Re: IF DAX Calculated Column

Works perectly, really appreciate it