Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Gmate88
Regular 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
Seward12533
Solution Sage
Solution Sage

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



View solution in original post

1 REPLY 1
Seward12533
Solution Sage
Solution Sage

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



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.