Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Loop within a loop

Hi, everyone.   I'm newer to Power BI, and I'm trying to mash 2 functions together to execute a loop within a loop. My first function, GetAllFolders, generates a table with 2 columns: FolderID an...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    =Table.FromRecords(List.TransformMany(Table.ToRecords(GetAllFolders(),each Table.ToRecords(GetAllQueuensinFolder([FolderName])),(x,y)=>x&y))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

=Table.FromRecords(List.TransformMany(Table.ToRecords(GetAllFolders(),each Table.ToRecords(GetAllQueuensinFolder([FolderName])),(x,y)=>x&y))

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for your help.
I pasted your function in Power BI like so:

And clicked "Invoke" and got this error:

 

Any ideas? Thanks again.

 

EDIT:

I think I wasn't putting the function in the editor correctly. I entered it like this now, and I still got the same error as above.

 

 

 

Thanks so much for your help. I am just learning this language.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    2 years ago

    my code just a example, you need complete it in your real circumstance.

    GetAllFolders() and GetAllQueuensinFolder() may have some arguements to fill.