Forum Discussion
Helper IVConditionally expanding a table in a column
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.
4 Replies
- amitchandak
Super User
vgeldbr , refer if this can help
vgeldbrThanks 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.
v-xuding-msftCommunity Support
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.
