Forum Discussion
Renaming multiple custom columns based on group id
Hi lwgpowerbiadmin ,
You can do it in Power Query Editor.
Example:
For the solution, please refer to:
Rename column names in a dynamic way with #Excel #PowerQuery | wmfexcel
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Thank you for replying.
The given solution will not work as the customfields are already assigned in the matrix.
The matrix visual will display error if the field name does not match. we cannot change the fields in the matrix every time.
In the matrix all the customfields values are coming correctly but the column header won't change. I have another table for this dynamic header for the custom fields.
The matrix have static fields,DAX measures and 8 dynamic custom field that can change according to group.
Solution needed for changing custom fields header name according to the groupID in a matrix/table.
Thanks