Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'd like to rename my columns either on import or immediately following.
Example name that comes in: [DIM A].[YEAR].[YEAR].[MEMBER_CAPTION]
Name I want to display: Year
Is there a formula for this?
Solved! Go to Solution.
Hi @cdknuth,
In query editor, it support rename multiple columns at same time, it can be parameters with list who store lists with 'old name', 'new name'.
#"Renamed Columns" = Table.RenameColumns(#"Previous Steps",
{{OldName,NewName},{OldName1,NewName1},{OldName2,NewName2},{OldName3,NewName3}})
In addition, use sql statement in advanced option to replace column names also works for your requirement.
Regards,
Xiaoxin Sheng
In power Query, right click the column header - > Rename.
Thanks
Raj
Thanks, Raj. But I'm looking for a way to rename 5-10 columns at once while importing into Power BI from SSAS.
Hi @cdknuth,
In query editor, it support rename multiple columns at same time, it can be parameters with list who store lists with 'old name', 'new name'.
#"Renamed Columns" = Table.RenameColumns(#"Previous Steps",
{{OldName,NewName},{OldName1,NewName1},{OldName2,NewName2},{OldName3,NewName3}})
In addition, use sql statement in advanced option to replace column names also works for your requirement.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |