Forum Discussion
Solved
How do I only expand the first row of a table?
Hi!
I only want to return the first result from each table from each row. How do I do this? Some tables only have 1 item, others have 4 or more, the first is always the one I want.
Formula after I expand the tables:
= Table.ExpandTableColumn(#"Expanded Device", "NetworkInterface", {"sNetworkAddress", "sNetworkName"}, {"sNetworkAddress", "sNetworkName"})
Picture to match formula:
Thanks!
You can add a custom column with the formula
Table.First([Networkinterface])
Expand this new column.
Or you can integrate Table.First() in you a.m. formula.
1 Reply
You can add a custom column with the formula
Table.First([Networkinterface])
Expand this new column.
Or you can integrate Table.First() in you a.m. formula.