Forum Discussion
How to deal with changing column meaning.
Hi, i am a power querry novice and i have a lot of .xls files to transform. All colums have the same meaning exept one that changes meaning. What is the best way to tackle this? The data is the same.
1 Reply
Hi Didrik ,
1. You can use custom formulas in the Power Query editor to deal with changing column names.
powerbi - How to deal with changing column names - Stack Overflow
2. If the position of the column is constant, you can change the column type by position.
Change Column Type By Position in Power Query - BI GorillaBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
