Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper V
8 years ago
Solved

If Datesbetween True then Return Blank Future Dates

Hi guys,

 

I'm currently having trouble getting this statement right. 

Here is the situation,

If Date 1 ISBLANK and Date 2 ISBLANK return blank and if Date1 is greater than Date 2 return Future Date.

I don't know how to write this logic in DAX.

 

Can someon1 please help?

Need Help
Show and Tell
Tutorial Requests
  • Stachu's avatar
    Stachu
    8 years ago

    quite simple - with NOT :)

    Column = IF(ISBLANK([Date1]) && 
            NOT(ISBLANK([Date2])), BLANK(),
         IF(YEAR([Date1]) > YEAR([Date2]),"Future"," "))

5 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    8 years ago

    this is for a calculated column?
    Something like this should work

    Column =
IF (
    ISBLANK ( Table[Date1] ) && ISBLANK ( Table[Date2] ),
    BLANK (),
    IF ( Table[Date1] > Table[Date2], Table[Future Date], BLANK () )
)
    • Stuznet's avatar
      Stuznet
      Icon for Helper V rankHelper V
      8 years ago

      Stachuthank you for your response.

       

      I revised the DAX function you provided.

      Column = IF(ISBLANK([Date1]) && 
            ISBLANK([Date2]), BLANK(),
         IF(YEAR([Date1]) > YEAR([Date2]),"Future"," "))

      and I would like to change Date2 to is not blank, how do I revise it?

      • Stachu's avatar
        Stachu
        Icon for Community Champion rankCommunity Champion
        8 years ago

        quite simple - with NOT :)

        Column = IF(ISBLANK([Date1]) && 
            NOT(ISBLANK([Date2])), BLANK(),
         IF(YEAR([Date1]) > YEAR([Date2]),"Future"," "))