Forum Discussion
Hierarchy in Power Query Editor
I am trying to create a table from data that already has parent details in it, with the aim that there is a text value for each level of the hierarchy, for each 'Name'- I don't know if its my logic thats at fault, or maybe I need to do some further modelling, but I can't work out what to do without doing a massive IF statement for each column?
Below is an example of my table with the data that is already present from the datasource. The 'ID' and the 'Name' columns are unique and I ultimately want for example, for a Level 7 name, the level 6 column should have the name that matches Level 6 for the Parent 6 column, then Level 5 would have the name that matches Parent 5 etc etc. So then when I use a slicer it will have those hierachy steps in? Those columns are currently blank, and I can't work out how to fill them, fill down won't work as the names need to be connected to the 'Parent' column.
1 Reply
ID Parent 1 Parent 2 Parent 3 Parent 4 Parent 5 Level Name Level 7 Level 6 Level 5 Level 4 Level 3 Level 2 Level 1 10000 PHL-A-10 PHL-A-10-10 PHL-A-10-10-10 PHL-A-10-10-10-10 PHL-A-10-10-10-10-1000 6 tdlnt tdlcdlivcxbldl null tdlnt tdlcdlivcxbldl null null null null null 10900 PHL-A-10 PHL-A-10-10 PHL-A-10-10-10 PHL-A-10-10-10-20 PHL-A-10-10-10-20-1090 7 dlxtdltncxl Ddlvdllpkpmdlnt Incpkmdl dlxtdltncxl Ddlvdllpkpmdlnt Incpkmdl null null null null null null 25000 Unassigned 2 Intdltncxl Incpkmdl: cxdministtcxtipkn Fdldl null null null null null Intdltncxl Incpkmdl: cxdministtcxtipkn Fdldl null 63100 PHL-A-10 PHL-A-10-10 PHL-A-10-10-40 PHL-A-10-10-40-10 PHL-A-10-10-40-10-6310 5 Scxldl Ptpkcdldlds - Hpkusing Ptpkpdlttidls null null Scxldl Ptpkcdldlds - Hpkusing Ptpkpdlttidls null null null null null [Account] 1 Npkt cxppliccxbldl null null null null null null Npkt cxppliccxbldl null PHL-A-10 PHL-A-10 3 pkpdltcxting Sutplus null null null null pkpdltcxting Sutplus null null null PHL-A-10 PHL-A-10-10 PHL-A-10-10 4 Tutnpkvdlt null null null Tutnpkvdlt null null null
