Hello,

Looking for some support regarding the following question.


  • Any SKU that Has05Reason equal to "Yes" AND Has98Reason = Yes then I want to be able to:
    • Return a column and/or measure that says "Yes" the SKU Has05and98Reason


  • Example1: SKU 123 would have "Yes" marked in Has05and98Reason
  • Example2: SKU 456 would have "No" marked in Has05and98Reason
  • Example 3: SkU 789 would have "Yes marked in Has05and98Reason


RecordID SKU Has05Reason Has98Reason Has05and98Reason 1 123 Yes No

2 123 No Yes

3 456 Yes No

4 456 Yes No

5 789 Yes No

6 789 No Yes

7 789 No Yes


I very much appreciate any help/expertise here.

Thanks,
Cam