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: 10,686
    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,638
    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,552
    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,620
    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,517
    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,665
    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,598
    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,646
    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,773
    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,697
    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,515
    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,624
    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,687
    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,608
    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,344
    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,220
    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: 1,021
    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,400
    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,383
    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,789
    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,836
    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