Power Query - Split Table Dynamically

🚀 Explore the power of Power Query with our latest tutorial! Learn how to dynamically split your dataset into two using the powerful Table.SplitAt function. 📊 Watch as we guide you through the process of reconstructing and pivoting your tables seamlessly using nested Let statements. 💡 Level up your data transformation game with this step-by-step tutorial! 🔧
#powerquery #dataanalytics #powerbi #powerbidesktop #mquery #DataTransformation #ExcelTips #TutorialTime 🎥

Follow along files
https://github.com/jbotes/powerbiTuto...
https://github.com/jbotes/powerbiTuto...

M-query functions used

Table.split to Split a table into many
https://learn.microsoft.com/en-us/pow...

List.transform to create a new list applying a transform to a list.
https://learn.microsoft.com/en-us/pow...

table.selectrows returns table that meets specific conditions
https://learn.microsoft.com/en-us/pow...

Table.removecolumns to remove columns from a table
https://learn.microsoft.com/en-us/pow...

Table.promoteheaders to promote the rows in a table to the header
https://learn.microsoft.com/en-us/pow...

Table.unpivotothercolumns to translate all other columns (other than specified) into attribuet value pairs.
https://learn.microsoft.com/en-us/pow...

Table.combine returns a table by merging a list of tables.
https://learn.microsoft.com/en-us/pow...

Highlighted Techniques
1 - Using a Nested Let Statement in a new column
2 - Using a variable in a query (as step) to feed a value in a function