Page 1 of 41 1 2 3 11 ... LastLast
Threads 1 to 20 of 805

Forum: Power Query (Get & Transform) & M code

Help with using Power Query (the Get & Transform feature in Excel 2016) including user interface driven transformations and M code construction and maintenance.

  1. Post Sticky Thread Sticky: Master Power Query with our book - M is for Data Monkey

    Started by Ken Puls, 2016-03-31 07:38 PM
    2 Pages •
    1 2
    5 Attachment(s)
    • Replies: 15
    • Views: 16,164
    Ken Puls
    2020-05-04, 08:03 PM Go to last post

  2. Post Sticky Thread Sticky: Installing Power Query

    Started by Ken Puls, 2016-03-31 07:55 PM
    • Replies: 5
    • Views: 15,557
    Ken Puls
    2017-06-08, 09:32 PM Go to last post

  1. Please help with a DataSource.Error when merging two connections in power query

    Started by Simonf, 2021-02-25 01:41 PM
    errors, excel, merge queries, power query
    • Replies: 1
    • Views: 93
    Ken Puls
    2021-02-25, 08:03 PM Go to last post

  2. VLOOKUP functionality in Power Query

    Started by zz_zz, 2021-02-23 05:30 AM
    2 Attachment(s)
    • Replies: 2
    • Views: 138
    Ken Puls
    2021-02-23, 07:16 PM Go to last post

  3. Combine Files With Monkey Tools' Smart Folder

    Started by ParserMonster, 2021-02-18 11:05 PM
    firewall, monkey tools, smart folder 3 Attachment(s)
    • Replies: 9
    • Views: 322
    ParserMonster
    2021-02-23, 01:16 AM Go to last post

  4. Cannot pass column values to List.Generate()

    Started by Ron Coderre, 2018-09-08 04:12 PM
    2 Attachment(s)
    • Replies: 7
    • Views: 1,277
    harlanwf
    2021-02-17, 05:32 AM Go to last post

  5. Language M - if statement on several lines

    Started by synetiax, 2021-02-12 05:13 PM
    language m, several lines 3 Attachment(s)
    • Replies: 5
    • Views: 284
    Ken Puls
    2021-02-16, 06:30 PM Go to last post

  6. Best practice - Multiple queries vs one 'landed' query/use of references

    Started by vpschroeder, 2021-01-09 05:04 PM
    • Replies: 2
    • Views: 1,013
    vpschroeder
    2021-02-13, 03:07 PM Go to last post

  7. Find column with maximum rows

    Started by BatTodor, 2021-02-11 01:27 PM
    2 Attachment(s)
    • Replies: 4
    • Views: 306
    BatTodor
    2021-02-13, 01:02 PM Go to last post

  8. Incrementing index on multiple categories - Power Query M

    Started by olabodeoa, 2021-02-10 01:39 AM
    incremental, index, power query
    • Replies: 6
    • Views: 338
    olabodeoa
    2021-02-11, 03:05 PM Go to last post

  9. Power Query - Auto Detect M Code

    Started by jilbobagins, 2021-02-08 12:34 PM
    • Replies: 1
    • Views: 264
    AliGW
    2021-02-08, 06:08 PM Go to last post

  10. Power Query and normal Excel cells

    Started by Xavier, 2021-02-04 06:35 PM
    • Replies: 1
    • Views: 147
    pinarello
    2021-02-05, 12:39 AM Go to last post

  11. Sum multiple columns in PQ

    Started by beagleton, 2017-07-10 10:04 PM
    2 Pages •
    1 2
    1 Attachment(s)
    • Replies: 14
    • Views: 6,353
    jilbobagins
    2021-02-05, 12:33 AM Go to last post

  12. Splitter.SplitTextByAnyDelimiter Show the Delimiter Used

    Started by jilbobagins, 2021-02-01 12:36 PM
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 12
    • Views: 436
    pinarello
    2021-02-04, 12:47 AM Go to last post

  13. Datasource: XLS(x) vs CSV?

    Started by Nick Burns, 2021-01-22 02:33 AM
    1 Attachment(s)
    • Replies: 7
    • Views: 548
    Ken Puls
    2021-01-22, 10:24 PM Go to last post

  14. Formatting trouble in Power Query

    Started by clmish, 2021-01-20 07:41 PM
    powerquery
    • Replies: 2
    • Views: 233
    clmish
    2021-01-21, 03:25 PM Go to last post

  15. load, transform and combine multiple tables

    Started by Anonymous1, 2021-01-19 11:14 PM
    binaries, combine, multiple tables, transform 5 Attachment(s)
    • Replies: 5
    • Views: 307
    pinarello
    2021-01-21, 01:07 AM Go to last post

  16. Custom Quarter over Quarter

    Started by Sagittariu5, 2021-01-18 06:05 PM
    • Replies: 1
    • Views: 305
    Sagittariu5
    2021-01-18, 07:09 PM Go to last post

  17. Power Query Performance Issues

    Started by asjones987, 2021-01-06 07:55 PM
    excel, performance, power querey, sheets
    • Replies: 2
    • Views: 693
    asjones987
    2021-01-07, 03:29 PM Go to last post

  18. Query for large amounts of data from Oracle and error Oracle: ORA-04031

    Started by Steffem, 2021-01-06 07:33 PM
    • Replies: 1
    • Views: 409
    pinarello
    2021-01-07, 10:35 AM Go to last post

  19. Post Convert to Parameter remains inactive

    Started by Giuseppe, 2020-12-23 04:55 PM
    convert, parameter, power query 4 Attachment(s)
    • Replies: 9
    • Views: 2,991
    pinarello
    2020-12-26, 02:01 AM Go to last post

  20. Eliminate lasts characters from field by list loop criteria

    Started by pepito, 2020-12-21 05:44 PM
    delimitator, list, loop 3 Attachment(s)
    • Replies: 4
    • Views: 1,312
    pinarello
    2020-12-22, 06:37 PM Go to last post
Page 1 of 41 1 2 3 11 ... LastLast

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Gravatar by 1e2.it