Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Column with Ifs/And statement

Hi - I'm new to BI and trying to figure out the best way to create the below  custom column in an existing report.   Looking to return 'accept' in the new column if each Col A/B/C contain any of th...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try this measure:

    Measure = IF(MAX(Report1[Col A]) in FILTERS(Report2[Col 1])&&MAX(Report1[Col B]) in FILTERS(Report2[Col 2])&&MAX(Report1[Col C]) in FILTERS(Report2[Col 3]),"Accept","Pass")

    And the result shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try this measure:

Measure = IF(MAX(Report1[Col A]) in FILTERS(Report2[Col 1])&&MAX(Report1[Col B]) in FILTERS(Report2[Col 2])&&MAX(Report1[Col C]) in FILTERS(Report2[Col 3]),"Accept","Pass")

And the result shows:

Hope this helps.

 

Best Regards,

Giotto Zhi