Forum Discussion
Power Query swaps one column data with other column
I realised strange situation while importing customer weekly sales reports from folder. It looks work fine, no error at the begining then I realised the case only for one week data, city column data ...
Can you please share the code that is in the Advanced Editor of the original screenshot you shared?
If you are using a custom function we may need to see the code for that as well.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
I shared the M code in my first post but if it is not enough I can send again... I find a manual way, I coppied the data to completly new excel sheet without and save then update, currently it worked, but of course it is annoying...
Thanks ,