question

RobertD-6802 avatar image
0 Votes"
RobertD-6802 asked DSPatrick answered

Power Query - get value of a column where the column is an occurence in a list of column names

Situation is I have defines a list of columns names (LISTCOLUMNS), e.g. Name0, Name1, Name2, Name3, Name4.
For any given row, I know which column name I need and have established the index 1 through 4.
For example,
Row 1 has Index 3 and therefore needs to get the value of Name3,
Row 2 has index 1 and therefore needs to get the value of Name 1.

This formula
= Table.AddColumn(#"Added Custom2", "Custom1", each [ListColumns]{0}) will retrieve the column text "Name0" but not the value for the value of Name0 in that row.

How can I achieve this?

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services


--please don't forget to Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.