Count Number Products Battle: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533

Download Excel Start Files:
Download Excel Finished Files: In this video compare five methods to count how many products are in a column.
(00:05) Introduction
1. (01:25) Excel Spreadsheet Function: COUNTIFS
2. (03:23) Excel Standard PivotTable
3. (04:47) Power Query: Group By feature
4. (07:23) DAX Functional Language of Excel Power Pivot & Power BI DAX: COUNTROWS
5. (11:08) Office 365 Dynamic Array Functions: UNIQUE & COUNTIFS
(14:40) Summary
Entire page with all Excel Files for All Videos:
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *