Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
quite simple - with NOT 🙂
Column = IF(ISBLANK([Date1]) && NOT(ISBLANK([Date2])), BLANK(), IF(YEAR([Date1]) > YEAR([Date2]),"Future"," "))
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 () ) )
@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?
quite simple - with NOT 🙂
Column = IF(ISBLANK([Date1]) && NOT(ISBLANK([Date2])), BLANK(), IF(YEAR([Date1]) > YEAR([Date2]),"Future"," "))
glad to help 🙂