Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In Power BI, I have a table that has a column of tables. See screenshot below:
Inside of the column called ThirdTable, each has a table that has the final information I’d like to grab. Specifically, the row with the value “Title”. See below for a screenshot of that table:
The simple query I’ve written is as follows:
let
finalRow = Table.SelectRows([ThirdTable], [Name] = "Title")
in
finalRow
The issue is that Power Query ends up searching for the [Name] column on the higher level table, and it ends up failing because there is no [Name] column on the higher level. I’d really just like to be able to reference the [Name] column from [ThirdTable]. I’d like to do something as simple as [ThirdTable].[Name] or something like that.
Solved! Go to Solution.
You may add step below.
= Table.TransformColumns(#"Added Custom", {"ThirdTable", each Table.SelectRows(_, each ([Name] = "Title"))})
You may add step below.
= Table.TransformColumns(#"Added Custom", {"ThirdTable", each Table.SelectRows(_, each ([Name] = "Title"))})
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |