cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gmate88 Visitor
Visitor

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

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.

 

 

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Seward12533 New Contributor
New Contributor

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

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



1 REPLY 1
Seward12533 New Contributor
New Contributor

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

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