Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |