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've looked around the forum prior to creating a new thread.
Thanks to Stachu helped me on this previously. Now I need to add an OR satement into this function and I'm struggling to do so and keep getting an error syntax 😞
Here is the logic, If Date 1 and Date 2 is blank then return "Blank" OR if Year(Date1) is greater than Year Date2 return "Future".
How do I go about adding an OR statement?
Column = IF(ISBLANK([Date1]) && NOT(ISBLANK([Date2])),BLANK(), IF(YEAR([Date1]) > YEAR([Date2]),"Future",""))
Solved! Go to Solution.
Hey,
you can use this DAX statement to create a calculated column ...
calculated column = IF( OR( AND(ISBLANK('table'[date1]),ISBLANK('table'[date2])) ,YEAR('table'[date1]) > YEAR('table'[date2]) ,"Future" ,"Blank" )
Hopefully this is what you are looking for.
Regards,
Tom
Hey,
you can use this DAX statement to create a calculated column ...
calculated column = IF( OR( AND(ISBLANK('table'[date1]),ISBLANK('table'[date2])) ,YEAR('table'[date1]) > YEAR('table'[date2]) ,"Future" ,"Blank" )
Hopefully this is what you are looking for.
Regards,
Tom
Thank you
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |