Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, you can see how to calculate distinct count in a data set using Power Query. This is the second video in a series looking at solutions to a Data Analysis Challenge that I gave to viewers.

If you’d like to read the accompanying blog post on my website, you can access it here:
https://www.excelcampus.com/powerquery/count-unique-rows-power-query/

Related Videos:
2 Ways to Calculate Distinct Count with Pivot Tables:
https://www.excelcampus.com/pivot-tables/distinctcount-pivot-tables/
Excel Data Analysis Challenge - Count Transactions with Multiple Rows:
https://www.youtube.com/watch?v=_3lX1NwIfzQ
Power Query Overview - Automate Data Tasks in Excel & Power BI:
https://www.youtube.com/watch?v=vq9AgAtSvQg
How to Combine Excel Tables or Worksheets with Power Query:
https://www.youtube.com/watch?v=HcfKOusOJhA&t=17s

#MsExcel #ExcelCampus
00:00 Introduction
00:21 Questioon
01:30 Solution
04:20 Adding New Data