Forum Discussion
Helper ISplit tables in different rows
It looks like I forgot to upload the file earlier. Check it out. It is working based on your sample tables. Have a look and see what you might be doing differently on the real data. Otherwise share a file with the real data (or a dummy that reproduces the issue).
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Community ChampionHi Itzarthi
You can do this best in PQ. Place the following M code in a blank query to see the steps. See it all at work in the attached file.
let
Source = Table.NestedJoin(Fil, {"Fil #"}, CP, {"Fil #"}, "CP", JoinKind.LeftOuter),
#"Merged Queries" = Table.NestedJoin(Source, {"Fil #"}, Win, {"Fil #"}, "Win", JoinKind.LeftOuter),
#"Expanded CP" = Table.ExpandTableColumn(#"Merged Queries", "CP", {"CP"}, {"CP"}),
#"Expanded Win" = Table.ExpandTableColumn(#"Expanded CP", "Win", {"Win"}, {"Win"}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Expanded Win", {"Fil #", "Fil"}, "Win/CP", "Date"),
#"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Columns",{"Fil #", "Fil", "Date", "Win/CP"}),
#"Sorted Rows" = Table.Sort(#"Reordered Columns",{{"Fil #", Order.Ascending}, {"Date", Order.Ascending}})
in
#"Sorted Rows"Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers