Forum Discussion

rmjersey's avatar
rmjersey
New Member
8 years ago
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...
  • ImkeF's avatar
    ImkeF
    8 years ago

    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

rmjersey's avatar
rmjersey
New Member
8 years ago

Thank you so much ImkeF :smileyvery-happy:, very close to a solution now...

 

Some of the fields in the new column show as Error (because there are no workstations):

"Expression.Error: There weren't enough elements in the enumeration to complete the operation."

I therefore cannot expand the column yet.

 

Does this need to be fixed in the code for my Function (so that the function always returns someting even if there are no workstations?)

Or is there something I can do in the Table.ExpandTableColumn code to deal with that case?

 

Thanks,

Richard

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi rmjersey,

Have you resolved your issue? If you have, welcome to share your own solution, or mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

Best Regards,
Angelia