how to reproduce 'Filtered rows' from PowerQuery?

[marma330]

I am trying to emulate some steps done in PowerQuery...

I can reproduce most of them (specially the ones with the gear button, which shows the exact code), but the ones like 'filtering', in the properties it's blank...

For example I am trying to reproduce the 'Filtered rows' from here:

But I do not know how to reproduce it since there is no specification

[camargos88 · Accepted solution]

@marma330 ,

You can click on Advanced Editor, it shows all the steps and you can code based on it.

Also you can enable the formular bar... Click on View -> check the item Formula Bar.