Forum Discussion
Solved
Iterating / changing query parameter to build a merged table
Hi, I'm new to PowerBI (1-2 hours playing around, no background reading) but very impressed so far. Hopefully someone can give me a pointer with my first PowerBI challenge... I am using a web da...
Well done! So if you have the function already, all that's left to do is to
1) transform your list of ClientIDs to a table (tab: List Tools -> Convert -> To Table) and
2) add a column (tab: Add Column -> General -> Custom Column
3) In the dialogue, call you function (for each row), passing [Column1] as the parameter that holds the Client ID
4) Expand that column
So, most likely, you are going to need to build a function in M which you would then call as you interate over your List of client ids. MarcelBeug or ImkeF are probably the best people to help out with that.
If you want some basics of how this works, have a look at this article: