Add prefix to specific columns at once with List.Zip in Power Query | Power BI
In this channel I post Power BI tutorials on how to improve your Power BI dashboard. I share tips for Power BI beginners. Learn more about Power BI, DAX, Power Query, Power Automate and Microsoft Fabric.
In this video I am showing how to add a prefix or suffix or rename any columns in a systematic way by using List.Zip function in Power Query editor. This technique works in Power BI and Excel.
Please note there is another function that allows to add prefix to all columns at once Table.PrefixColumns. However, it is less flexible and it does not allow to exclude certain columns.
Previous Videos:
Control what column to export & load to Power BI:
• Control what columns to export & load...
Combine excel files from a folder using Power Query:
• Combine excel files from a folder usi...
Combine csv files from a folder using Power Query:
• Combine CSV files in Power Query with...