Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |