Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |