Forum Discussion
Solved
INDEX MATCH in Power BI
Hello, I have tried a ton of suggestions in this forum but they are falling a little short for what I'm needing. Below are samples of my data, first on the left is my pn to model reference and the ...
Hi, Pretengineer
You can create a calculated column as below:
Match _PN = CALCULATE ( MAX ( PLM_DATA[PLM_PN] ), FILTER ( PLM_DATA, CONTAINSSTRING ( AP_DATA[aP_Model], PLM_DATA[PLM_Model] ) ) )Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
This solution works great for my need, thank you, do you think it also works fine for large data?
thanks again.
You are welcome. No better way of knowing than trying.