POWER QUERY INDEX MATCH SIMILARITY

[jonastiger]

Hi
I wonder if it is possible to convert this excel formula in M language:

=IFERROR(IF(INDEX(Table1[Team],MATCH([@GP];Table1[ID],0))=INDEX(Table1[Team],MATCH([@CT],Table1[ID],0)),INDEX(Table1[Team],MATCH([@GP],Table1[ID];0));"NA");"")

or something simplier

I've tried some M function combination but can´t make it work.

Thank you very much in advance
JT

 

[Chihiro]

Index/Match or Lookup operation is basically Join (merge) in PQ. However, from your formula, you want to do multi-step validation and join multiple tables.

I'd recommend you upload sample workbook that has all the tables, and your desired output from it. Without it, we'd be stabbing in the dark.