Forum Discussion
Accessing table and field from NestedJoin
You can try expanding the tables after the join df555 then getting the columns. That is the easiest way.
= Table.SelectColumns(Table.ExpandTableColumn(Table.NestedJoin(Custom1, {"Digital Property"}, Table, {"Digital Property"}, "Table", JoinKind.LeftOuter), "Table", {"Custom"}, {"Custom"}),{"Digital Property", "Custom"})Otherwise, you'll need to provide some data because I'm guessing what yours looks like.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
You can try expanding the tables after the join df555 then getting the columns. That is the easiest way.
= Table.SelectColumns(Table.ExpandTableColumn(Table.NestedJoin(Custom1, {"Digital Property"}, Table, {"Digital Property"}, "Table", JoinKind.LeftOuter), "Table", {"Custom"}, {"Custom"}),{"Digital Property", "Custom"})Otherwise, you'll need to provide some data because I'm guessing what yours looks like.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
