Skip to main content

    Power BI

    Needs Votes

    Power Query Renaming a column based on position rather than existing column name

    Vote (3) Share
    Wyn Hopkins's profile image

    Wyn Hopkins on 15 Mar 2018 10:03:13

    It's currently not possible to rename a column without the M code referencing the existing column name (not without the use of complex function). It would be great if we could easily rename based on Column number as well. E.g. Column2 will be renamed as "Region" regardless of what Column2 is currently called. This prevents issues with future refreshes when the promoted header from column 2 changes