Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper 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...
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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper 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

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper V
7 years ago

Thank you