IF OR Statement

[Stuznet]

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","")) 

[TomMartens · Accepted 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

[Stuznet]

Thank you