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.