Forum Discussion

donpep0's avatar
donpep0
Frequent Visitor
4 years ago

Split table into multiple tables based on value of 2 columns

Hi! I'm working with Power Query and I need to split the main table into multiple tables. It's possible to split a table into multiple tables based on 2 value conditions?   I have the below table ...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi donpep0 

 

Power Query doesn't support to split a query into multiple queries based on values. For a better modeling and report authoring experience, it is not recommended to split same structure data into multiple queries too. 

 

You can try the Group By feature to get a similar result in one single query as below. After grouping, you will have a table column. Every cell in this column is a table that only has data of this product-weekdate group. You can choose to expand the table column then every goup data will be together. Grouping or summarizing rows - Power Query | Microsoft Docs

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.