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]
)

     

     

     

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Cramos

 

Try using this Dax:

 

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