Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances

From An Excel Table that stores Invoice data with line item data for invoices (duplicate invoice numbers in the Invoice Field (Column), learn how to use Power Query to create a Unique List of Invoice Numbers with Balances. See that the output from Power Query is dynamic and so updating the list when new invoices is dynamic.
Also see these videos:
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
Excel Magic Trick 1251: SUMIFS & Table Formula Nomenclature (Structured References) to Add Invoices

[DougHExcel]

Another fantastic PQ video...Group by is another winner!

[VS-rhrq]

great stuff with Power query....really helpful

[TheOndricek]

I love learning about Power Query. Thanks for sharing!

[TimSheets]

Loved the comparison "Group by is like doing sumifs". It's like a light bulb went off in my head. Thanks!

[entertainmentgalaxy]

@Excelisfun Great Tutorial. But i think this can be done with pivort table. Please correct if m wrong. Please dont stop and keep sharing. God Bless You.

Thanks

[troyfaircloth]

Mike,
Your presentations are always terrific. What screen capture / video playback software do you use? I want to make some videos like these for my team at work, but I am not sure where to begin.

[donnyguillen]

Nice video, love your channel. Question: when I try to pull data from a password protected workbook (already opened) there is always an error in the date column (whith any date format data) and numbers appear. Do you know a fix o this? Thanks

[ExcelStrategy]

Can we continue to call it Power Query even in Excel 2016 ?? new name upsets me a little... loool