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 D...
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"," "))
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"," "))
      • Stuznet's avatar
        Stuznet
        Icon for Helper V rankHelper V
        8 years ago

        Stachuyou're da best!!! thank you so much ^^