creating identifier based on column name

[Anonymous]

Hello PowerBi Friends,

i'm direct querying the follow table.

how can i create an identifier column, based on the name of each columns?

for example, i want a "LD" for all the columns that starts with "LD" and "DS" for all the columns that start with "DS"

so when end user select the identifier, the corresponding columns will show up in the table.

[amitchandak · Accepted solution]

@Anonymous , if this direct query then you have to unpivot that at source and create a new column with DS and LS.

In import mode in power query unpivot ,all such column

and create a new column like

if Text.Upper(Text.Start([Attribute],2)) = "LD" then "LD"

else if Text.Upper(Text.Start([Attribute],2)) = "DS" then "DS" else [Attribute]

and use this in visual