Forum Discussion

Cramos's avatar
Cramos
Frequent Visitor
9 years ago
Solved

IF function when Date is empty

Hi,    I have 3 columns with different dates. I need a function that:   IF Column Date1 is empty, take Column Date2, and if this one is empty, take Column Date3.   If i use Column(Date1)="", it...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Cramos

     

    Try using this Dax:

     

    NewDate =
IF (
    Table1[Date1] = BLANK (),
    IF ( Table1[Date2] = BLANK (), Table1[Date3], Table1[Date2] );
    Table1[Date1]
)

     

     

     

     

harshadshettiwa's avatar
harshadshettiwa
New Member
8 years ago

 I am facing a problem in the similar lines.

 

I am trying to evaluate if the date is bank but if function in DAX is not evaluating the date column (that is- the date column is greyed out) is it because I am using DirectQuery???

 

Is there any work around for this.?

Thanks

 

Harshad

MAkiva1's avatar
MAkiva1
Helper I
8 years ago

Try creating a new custom column instead of a new measure.  You may need to switch from DirectQuery to do this however.