Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

IF OR Statement

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

 

Need Help
Show and Tell
Tutorial Requests
  • TomMartens's avatar
    TomMartens
    7 years ago

    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

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    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