@excelisfun
@excelisfun
excelisfun | Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 @excelisfun | Uploaded 6 months ago | Updated 2 days ago
Download Excel File: https://excelisfun.net/files/EMT1854-1856.xlsx
Learn how to group transactions with no key or invoice number using Power Query and the Table.Group fourth and fifth arguments: groupKind and comparer function. Group By when there is no key column and there are duplicates and empty cells. How to group transactions with no transaction number and repeating dates and empty cells.
Topics:
1. (00:00) Introduction
2. (00:28) Group By Date Column with two aggregate calculations: join descriptions and sum amount.
3. (01:00) Text.Combine with Column Lookup to join descriptions
4. (02:10) Table.Group fourth argument: groupKind using GroupKing.Local or zero, 0
5. (02:56) Table.Group fifth argument: comparer function
6. (05:29) Summary
7. (05:43) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp
Examples of Table.Group fourth argument, groupKind argument
Examples of Table.Group fifth argument, Comparer argument
Table.Group fourth argument
Table.Group fifth argument
Table.Group groupKind argument
Table.Group comparer argument
Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856excelisfun Boomerangs Back With Gold Plaque!!! and more!!!!Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780Generate Letters A to Z in Excel #Short Excel Magic Trick 16BMX & Skate Park Adventure #14: Lake Stevens, Sunday, Sunday, March 27, 2022FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828Excel Formula: Extract City Name from Description. Excel Magic Trick 1839Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test ExampleBuild Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21

Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 @excelisfun