Forum Discussion
Solved
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...
- 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
Seward12533
Solution Sage
Solution SagePower 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
FuncLoc MilageType Value