Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
I don't know English, sorry for the mistakes.
I need help with Power Query.
I have n-columns and I need to keep the first 2 columns and the last 3 columns, the column names are different.
Thank you.
Gabriela
Solved! Go to Solution.
try this
tabClean=Table.SelectColumns(tab,List.RemoveLastN(List.RemoveFirstN(Table.ColumnNames(tab),3),2))
try this
tabClean=Table.SelectColumns(tab,List.RemoveLastN(List.RemoveFirstN(Table.ColumnNames(tab),3),2))
Super, thank you. It was very difficult for me.
Gabriela
| User | Count |
|---|---|
| 13 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |