Forum Discussion
How to split a table with data into multiple seperate tables.
Hi HafizNadeem
Unfortunately, it is not possible to divide a large table into several smaller ones automatically...
The attached link leads to a discussion of the same operation with a different logic
https://community.powerbi.com/t5/Desktop/Splitting-a-Table-into-several-tables-based-on-the-value-of-a/m-p/413068#M189602
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you for your reply can we achieve this through dynamic partitioning?
Unfortunately, PowerBI does not include such an option.
If it is an existing model, this can be done by duplicating and filtering one table at a time.
If it's a new model, pull each table separately.If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I mean to say in a tabular model??
Sorry , tabular model is out of my knowledge