Add value from one column to multiple columns as a prefix.

Question

Hi All,&nbsp;I am having trouble adding a prefix to multiple columns from one column.&nbsp;What i need to do is add the [Function Loc.] Column as a prefix into the [Milage] Cloumns.&nbsp;&nbsp;The only way I can do this us duplicate the Function Loc. and merge columns whic is ineffcient.&nbsp;&nbsp;Any help to get on the right path would be appreciated.&nbsp;&nbsp;

seward12533 · Accepted Answer

Power BI does not deal with columnar data well. Your best bet it to unpibot this table in PowerQuery first so you have a table ofFuncLoc MilageType Value

Forum Discussion

Add value from one column to multiple columns as a prefix.

1 Reply

Related content

Change the wording "use original column name as prefix"

Multiple headers on some columns based on column title prefix

Sequential Order column based on multiple criteria

Multiple line and clustered columns chart

Rename some columns by adding a prefix