Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a situation where I am peforming left outer join on two tables.
I need to select one column from each table/query, the problem is the second table becomes a nested table in the first one.
I want to know if there is any other way than using Table.ExpandTableColumn(). Is there any way to directly access column of a nested table.
Solved! Go to Solution.
You may also try LOOKUPVALUE Function in DAX.
You may also try LOOKUPVALUE Function in DAX.
@Nash It will be great if you can post some sample data and expected output as well.
Proud to be a PBI Community Champion
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
68 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |