If match multiple range

[silambarasan.J]

Hi,

Could you please advise how can I do index match with multiple ranges in Power BI.

I have two tables one is Data another one is Output sheet. If date a matched from table 1 into the Table 2 then return the output is "Yes", if not then return the output is "No".

Condition;

1. The qty column can't be 0 or blanks and it's always greater than 1 expect the Banana with area code KP1 and PP1 always equal to 1.
2. The "Sales code can't be blanks.
3. The "Watermelon" doesn't have area code.

Example;

item 123 the area code doesn't matched according to the table 1 so the out put is "Error" and replicated the value according to the Header.

Attached the file for your reference and snapshot.

[silambarasan.J]

Can I post Power BI question here? Please advise.

[oeldere]

With a pivot table.

See the attached file.

[silambarasan.J]

With a pivot table.

See the attached file.

Hi Oeldere,

Thanks for your reply and alternative suggestion but slightly different my actual output. How can achieve my actual result in Power query EXCEL?
Could you please advise.

[JeteMc]

If a formula based proposal is acceptable then paste the following into cell G2 and copy down:

Please Login or Register  to view this content.

Let us know if you have any questions.

[silambarasan.J]

thanks for your reply and take caring of my thread as a alternative solutions. The formulas working fine.
Could you please advise or guide line how can achieve the same thing in Power Query in Excel. Excel Help forum supporting the POWER BI or POWER QUERY question or not available at the moment?