Power query Help

[vjnvinod]

Hi Team

@Zubair_Muhammad 

How can i develop something in excel power query/power BI where i can perform bulk keyword search in excel reports
and it  provides the  search result in another worksheet & i can use that in power BI

[v-juanli-msft]

Hi @vjnvinod 

You could consider Lookupvalue function in DAX

https://www.c-sharpcorner.com/article/dax-in-power-bi-how-to-use-lookupvalue-function/

If you are unable to slove the problem by yourself, please share some data and expected result here.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.