If Datesbetween True then Return Blank Future Dates

[Stuznet]

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?

[Stachu]

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]

@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 · Accepted solution]

quite simple - with NOT 🙂

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

[Stuznet]

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

[Stachu]

glad to help 🙂