Forum Discussion
Power Query swaps one column data with other column
This sounds like a problem with your excel data source. Check the file for that one week and you'll see that the two columns were reorderd for that one file only. Easy fix is to swap their order around the right way in the source.
You could potentially fix this by promoting the headers inside the sample Excel files individually first and then combining the files, so using a custom function rather than just the custom column you currently have. This option would require all the Excel columns to be spelled exactly the same in each file.
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.
Hello AlliSon,
Thanks for advice but I did, but the reason of the issue seems different. (I am thinking on whether Greek language may cause?)
There is no differnce between source with others, LEFT image is problematic one (2 weeks), right one is normal (102 weeks). I am struggling still..
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 ,