Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am not much aware about M-code 

Please guide me on this more with any example

Please

JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago
This question is too broad to answer. Why can't you use the "remove columns" option in power query editor? What have you tried already? Where exactly are you getting stuck?