Forum Discussion
Resolver IFunction to loop through two columns in Power BI Desktop
Hi,
I am trying to build, with no success, a function in Power query that receives two columns as parameters from a previous query as input and loops through them.
Can you provide me a hint on how to achieve it?
Thank you,
Kind Regards Marta
4 Replies
- amitchandak
Super User
PowerBI88 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
refer these
https://www.edureka.co/community/37031/looping-in-power-query
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
PowerBI88Thank you for the references, I will give tham a look.
here are the steps that I am trying to achieve:
1) take the following table with the pairs (projectid, teamid) values
2) for each row of the previous table make a reast api call. That is pass these values as parameters to a query that I have already implemented with these value pairs as parameters.
V-lianl-msftCommunity Support
Please refer to this blog:
https://exceed.hr/blog/list-generate-and-looping-in-powerquery/
