Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transform)

preview_player
Показать описание
Download Excel Files:

See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Power Query.

Distinct Count Formula with one condition. Unique Count Formula with one condition.
Excel Magic Trick 1318: How Many Unique Visitors To Work Site Each Day? PivotTable or Array Formula?
Bill Szysz posted:
Excel, Power Query - zliczanie unikanych wartości z warunkiem
Other Video also:
Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables.
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:06:13

Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transfor...

Excel Magic Trick 0:05:07

Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables.

Excel Magic Trick 0:03:56

Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable?

Excel Magic Trick 0:12:38

Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula?

Excel Magic Trick 0:27:23

Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups

Excel Magic Trick 0:04:21

Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT

Excel Magic Trick 0:07:38

Excel Magic Trick 1272: Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods)

Power Query Running 0:07:25

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

Excel Magic Trick 0:06:55

Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transfo...

This Excel tutorial 0:08:01

This Excel tutorial showcases how to Count Unique Values

Best Ways to 0:01:24

Best Ways to Extract Distinct Records in Excel || Get Unique Items From a List in MS Excel

Excel Magic Trick 0:05:46

Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation

Excel Magic Trick 0:08:25

Excel Magic Trick 1312: Count The Number Of Mondays & Tuesdays Since Birth: NETWORKDAYS.INTL

Excel Magic Trick 0:13:38

Excel Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell

Count Products Report: 0:15:38

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

Excel Magic Trick 0:01:34

Excel Magic Trick 1358: Query Dependencies View in Power Query (Get & Transform)

Excel Magic Trick 0:26:42

Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)

Excel Magic Trick 0:08:03

Excel Magic Trick 1317: Formulas for Total Insulin Units… And Excel’s Golden Rule & MAX Replaces...

COUNTIFS in Power 0:02:12

COUNTIFS in Power Query? Excel Magic Trick 1549

Excel Magic Trick 0:21:20

Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & S...

30. Count Distinct 0:01:36

30. Count Distinct Values | Power Query Editor

how to get 0:02:04

how to get unique count in excel using formula

Count unique distinct 0:13:20

Count unique distinct values meeting criteria [Array Formula]

Excel Magic Trick 0:30:37

Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?

Комментарии
Автор

Power Query is the best Excel upgrade ever!!!Thanx for the video

lazalazarevic
Автор

Thanx for sharing this tip. Power Query rules!

at-excel
Автор

Nice video! Thanks for taking me into Group-By.
Nice feature.

OzduSoleilDATA
Автор

Hi, Awesome videos. Is it also possible to sum up value based on distinct condition?
Lets say there is an extra variable "FTE" where some people work 1.0 FTE and some people work 0.8 FTE.
Just like in your dataset sioux will have 3.0 FTE (summed) but i only want sioux FTE to be counted once. Is that possible within power query without having to delete duplicates?

lamle
Автор

Great video mike. Am enjoying Power query and power pivot

douglaszulu
Автор

Don't know if any one has mentioned this method but my simple way of doing this would be to add =COUNTIFS($A$12:A12, A12, $D$12:D12, D12) to column E. The trick here is that it counts up from 1 for each duplicate because the top cell is locked but the rest of the range is not. You can then do a SUMIFS against the date and unique count value of 1 which would give you the desired info.

I have used the above method many, many times the only limitation is the size of the data set which can cause excel to crash if you try and apply this formula against very large data sets (about 100, 000+)

deanrobinson
Автор

I get a daily transaction report which I summarise by product line and use a different table to add the customer name. PQ and PP helps automate by dumping the files in a folder the refresh the tables and voila the report is ready

douglaszulu