Forum Discussion

PedroPascual's avatar
PedroPascual
Helper I
3 years ago
Solved

QA comparicion between Values

Hi Community, hopefuly, you can help me with this formula. i need to do a QA based on values from different columns and tables.   table1 column1 column2 column3   QA value1 value2 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi PedroPascual ,

     

    We can create a calculated column.

    QA =
IF (
    AND (
        AND (
            'Table'[Column1] = "House",
            'Table'[Column2] = "cat"
                || 'Table'[Column2] = "dog"
                || 'Table'[Column2] = "rabbit"
                || 'Table'[Column2] = "lion"
        ),
        'Table'[Column3] = "book"
            || 'Table'[Column3] = "pencil"
    ),
    "YES",
    "NO"
)

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Ahmedx's avatar
Ahmedx
Super User
3 years ago

it's not clear what you want.
can you explain why there is no in next line:
house machine dog pencil lemon NO

  • PedroPascual's avatar
    PedroPascual
    Helper I
    3 years ago

    The rule I need to create in the formula is:

    if the value1 in Table1 and Column1 contains the other values "car", "dog", "pencil" & "apple"  is a "Yes", otherwise is a "NO".

    Other Values can be in the same table or in different tables, but with a relation with Value1