PowerPivot - Calculated Column Conundrum

[codilicj]

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