Conditionally expanding a table in a column

[vgeldbr]

I'm stuck and hope somebody has some ideas. I'm not a Power BI developer just a "power" user.

I have a query where there is a column that is an embedded table with 1, 2 or 3 rows. I want to expand that table based on a filter on the 1, 2 or 3 rows taking the "best" one based on the values of the column in the table. If there is only 1 row then take that, if there are two rows then take the "best" one based on the value in one or more of the columns.

What I would like to end up with is a record in [All Rows] containing the best row from the table. I think I can then easily expand taht record for the columns/fields I want.

[v-xuding-msft]

Hi @vgeldbr ,

You could learn from this blog: Conditionally expanding table’s columns with Power Query M language to create a function to implement it.

Hope it can help you.

[amitchandak]

@vgeldbr , refer if this can help

https://www.youtube.com/watch?v=wG3J8lO9d5I

https://www.youtube.com/watch?v=sbPS3ZKIt7g

[vgeldbr]

Thanks @amitchandak. The Guy in a Cube video is very old and really just addresses the simple scenario available from the UI. I had found and viewed Parker's video but have not been able to use what he describes for my specific scenario so I am not sure what I'm missing. I agree what he is doing is 99% of what I need though.

[amitchandak]

@vgeldbr , while it is difficult to tell without looking at data. This what I do.

I open these table see what option I have (with those two righ angles near to column name), row or column, look at data and take a call and repeat this till i reach last point in data.