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

[Gmate88]

Hi All,

I am having trouble adding a prefix to multiple columns from one column. What i need to do is add the [Function Loc.] Column as a prefix into the [Milage] Cloumns. 

The only way I can do this us duplicate the Function Loc. and merge columns whic is ineffcient. 

Any help to get on the right path would be appreciated.

[Seward12533 · Accepted solution]

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 of

FuncLoc MilageType Value