Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Helper IV
1 year ago
Solved

Split Master table into multiple tables dynamically based on column value

Hi all   I need to split a 'time recording' table into multiple tables (with exactly the same columns) based on the value in a single column named asset. The business use case is that the data need...
Need Help
  • BA_Pete's avatar
    BA_Pete
    1 year ago

    Hi Richard_Halsall ,

     

    The simple answer is no, you can't dynamically create these tables. Power Query can not spawn new queries internally.

    However, you could potentially pre-build the queries, but dynamically populate them something like the attached PBIX.

    This works ok if you've got a limited number of assets and a known maximum but, if you've got maybe 20+, this is going to be a bit of a PITA.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
1 year ago

Hi Richard_Halsall ,

 

The simple answer is no, you can't dynamically create these tables. Power Query can not spawn new queries internally.

However, you could potentially pre-build the queries, but dynamically populate them something like the attached PBIX.

This works ok if you've got a limited number of assets and a known maximum but, if you've got maybe 20+, this is going to be a bit of a PITA.

 

Pete

  • BA_Pete's avatar
    BA_Pete
    Super User
    1 year ago

     

    Also, genuine thank you for providing source data as M code. Makes it soooo much quicker/easier to grab and get started on ğŸ™‚

     

    Pete