Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have a table here:
This Table has a column called "ID" with nested tables in it that takes the "PseudoNo" Column and seperates the string by the "," . The "PseudoLines" column in the nested table in the above picture is where the seperated values go. So for Example 167 when broken up has 1 value "TSF24" and 2 Values of "TS12BLW".
What I'm trying to figure out is how to get the "PartDescr" Column within the Nested table that matches the "PseudoLines" Value. For example for row 167's nested table:
for each value in "PartNum" search for it in the "ID" nested table column and add if found in the "PseudoLines" column, add it's "Part Description" to the nested table. Is this possible in power query?
Thanks.
Solved! Go to Solution.
NewStep=let a=Table.Buffer(Table.Distinct(PreviousStepName,"PartNum")) in Table.TransformColumns(PreviousStepName,{"NestedTableColumn",each Table.AddColumn(_,"PartDescr",each a{[PartNum=[PseudoLines]]}?[PartDescr]?)})
NewStep=let a=Table.Buffer(Table.Distinct(PreviousStepName,"PartNum")) in Table.TransformColumns(PreviousStepName,{"NestedTableColumn",each Table.AddColumn(_,"PartDescr",each a{[PartNum=[PseudoLines]]}?[PartDescr]?)})
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |