Moving a specific column to the begining with a dyanamic table

[gjohal]

Hi!

I was wondering if anyone could help me with an issue I've ran into. I have a query that adds/deletes columns based on new information that it fetches however the last column or rather the Header for the last column in the query will always be the same. I wanted to move the last column to the beginning. My issue is that if I obtain new data and I refresh the query, an error will occur as Table.ReorderColumns requires the column headers to be listed and with columns being deleted and added that leads to an error.

Is there any way around this? Is there a way to make a specific column the first column in the query without referencing other column headings?

Thanks

 

[Nick Burns]

Take a look at Gil Raviv's Reorder Column Function
https://datachant.com/2017/01/18/power-bi-pitfall-4/

 

[gjohal]

Thanks a lot! The function worked and that site seems really helpful for in case I run into other issues.