advanced editor

  1. O

    insert Regex trick at any step (mid?) Advanced Editor

    Trying to use run the Regex trick (that members Grah and Bo_Ry skillfully adapted for this case), I run into a problem which might have to with my worksheet not being a table. The error text is: Expression.Error: The field 'Comment' of the record wasn't found. Details: Name=Sheet1 Data=...
  2. S

    Filter Table.SelectRows from cell rang in sheet

    I Imported some data from folder. folder has 100 txt file. I need select txt file based on names listed in column2 at sheet2. Originally they are selected manually in power query and code is like that: let Source =...
    • Shayanan
    • Thread
    • advanced editor powebi power queries
    • Replies: 1
    • Forum: Power Tools
  3. S

    Reference a cell in the Advanced Editor of Power Query Editor

    Hello, I'm trying to text in the advanced editor with a cell reference from a sheet in my workbook. I'm constantly having to manually update the advanced editor in 25 different tables which is taking me ~30minutes to run a report. Is it possible to do a cell reference for this? I've highlighted...
    • Sigmawolf101
    • Thread
    • advanced editor cell reference power query editor
    • Replies: 13
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top