Page 3 of 5 FirstFirst 12345 LastLast
Threads 41 to 60 of 82

Forum: ETL PQ Tips and Tricks

Extract, Transform, Load Tools, Power Query, Power Pivot and Power BI Tips and Tricks

  1. Cool Sticky Thread Sticky: more about PowerQuery aka Get&Transform (links)

    Started by sandy666, 06-10-2020 07:43 PM
    • Replies: 0
    • Views: 7,492
    sandy666
    06-10-2020, 07:43 PM Go to last post

  1. Cool PQ - How many Scores of 80 or more have been obtained by Subject - with Pivot Table

    Started by sandy666, 10-17-2020 04:25 PM
    • Replies: 0
    • Views: 1,476
    sandy666
    10-17-2020, 04:25 PM Go to last post

  2. Cool PQ - Transform data from vertical to horizontal with Table.FromRecords

    Started by sandy666, 10-16-2020 04:21 AM
    • Replies: 0
    • Views: 1,385
    sandy666
    10-16-2020, 04:21 AM Go to last post

  3. Cool PQ - Return header(s) of column(s) for maximum average

    Started by sandy666, 10-09-2020 07:47 AM
    • Replies: 0
    • Views: 1,462
    sandy666
    10-09-2020, 07:47 AM Go to last post

  4. Cool PQ - How to get Total via Power Query

    Started by sandy666, 09-23-2020 06:10 PM
    • Replies: 0
    • Views: 2,043
    sandy666
    09-23-2020, 06:10 PM Go to last post

  5. Cool PQ - Sum values for each label from defined range of columns

    Started by sandy666, 08-24-2020 04:11 PM
    • Replies: 0
    • Views: 1,486
    sandy666
    08-24-2020, 04:11 PM Go to last post

  6. Cool PQ - Calculate variances based on different model selections

    Started by sandy666, 08-23-2020 03:14 AM
    • Replies: 0
    • Views: 2,414
    sandy666
    08-23-2020, 03:14 AM Go to last post

  7. Cool PQ - Summary from template in single workbook

    Started by sandy666, 08-02-2020 07:59 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 2,469
    sandy666
    08-02-2020, 07:59 AM Go to last post

  8. Cool PQ - Count sub-levels in Pivot Table

    Started by sandy666, 07-29-2020 06:28 PM
    2 Attachment(s)
    • Replies: 0
    • Views: 2,569
    sandy666
    07-29-2020, 06:28 PM Go to last post

  9. Cool PQ - Calendar with user defined StartDate and EndDate

    Started by sandy666, 07-29-2020 01:08 PM
    • Replies: 0
    • Views: 3,461
    sandy666
    07-29-2020, 01:08 PM Go to last post

  10. Cool PQ - Add zero if there is a single digit after last delimiter (here: / )

    Started by sandy666, 07-24-2020 01:44 PM
    • Replies: 0
    • Views: 2,304
    sandy666
    07-24-2020, 01:44 PM Go to last post

  11. Cool PQ - Sort columns and rows

    Started by sandy666, 07-20-2020 09:59 PM
    • Replies: 0
    • Views: 2,465
    sandy666
    07-20-2020, 09:59 PM Go to last post

  12. Cool PQ - Extract initial letters string from longer string with different length

    Started by sandy666, 07-08-2020 04:29 PM
    • Replies: 0
    • Views: 5,122
    sandy666
    07-08-2020, 04:29 PM Go to last post

  13. Cool PQ - Sum columns with null values

    Started by sandy666, 06-10-2020 09:25 PM
    • Replies: 0
    • Views: 1,397
    sandy666
    06-10-2020, 09:25 PM Go to last post

  14. Cool PQ - Split multiple columns at the same time

    Started by sandy666, 05-27-2020 06:10 AM
    • Replies: 0
    • Views: 1,163
    sandy666
    05-27-2020, 06:10 AM Go to last post

  15. Cool PQ - Distinct vs Unique

    Started by sandy666, 05-22-2020 12:49 PM
    • Replies: 0
    • Views: 1,040
    sandy666
    05-22-2020, 12:49 PM Go to last post

  16. Cool PQ - How to extract first and last time from text in single cell

    Started by sandy666, 05-19-2020 12:17 PM
    • Replies: 0
    • Views: 879
    sandy666
    05-19-2020, 12:17 PM Go to last post

  17. Cool PQ - Numbering duplicates in ascending order

    Started by sandy666, 05-16-2020 04:24 AM
    • Replies: 0
    • Views: 1,152
    sandy666
    05-16-2020, 04:24 AM Go to last post

  18. Cool PQ - Non standard approach to Counting Distinct entries by group

    Started by sandy666, 05-15-2020 07:26 AM
    • Replies: 0
    • Views: 1,259
    sandy666
    05-15-2020, 07:26 AM Go to last post

  19. Cool PQ - Table.Split - split single table to three tables by year - less flexible

    Started by sandy666, 05-14-2020 09:50 PM
    • Replies: 0
    • Views: 1,582
    sandy666
    05-14-2020, 09:50 PM Go to last post

  20. Cool PQ - Table.Partition - split single table to three tables by year

    Started by sandy666, 05-14-2020 07:35 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 2,571
    sandy666
    05-14-2020, 07:35 AM Go to last post
Page 3 of 5 FirstFirst 12345 LastLast

Forum Information and Options

Moderators of this Forum

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