Forum Discussion
How to remove unwanted columns dynamically
Hi I wish to remove unwanted columns from data by using "M-Code", not option "remove other colums in query editor. Ref Link below Link Thanks
Hi Anonymous ,
Yes,for my .pbix file,pls click here.
Go to "edit queries">"Table">"steps",you will find my M-code there.
Best Regards,
Kelly
v-kelly-msft
Community Support
Community SupportHi Anonymous ，
You can use M-code such as below:
= Table.RemoveColumns(Source,{"test"}&{"test 2"})
{"test"}{"test 2"} are the tables I removed,and you will see that in my previous table there are 3 columns:Date ,test, test 2,and with the M-code,there are only 1 column left.
Best Regards,
Kelly
Thank you!
I tried the way you suggested, but not success got. could you please share your BI file to understand the same? if possible
Thanks occe again.
- v-kelly-msft
Hi Anonymous ,
Yes,for my .pbix file,pls click here.
Go to "edit queries">"Table">"steps",you will find my M-code there.
Best Regards,
Kelly
not able to download
- v-kelly-msft