Solution to Challenge-10 | Power Query M | Unique Combination| Groupby|List.Distinct| Table.Distinct

Solution to Tenth (10th) Challenge Using Power Query M

In this video, I’ll show you two practical techniques to calculate the number of unique visits per route in Power Query using M language.

You’ll learn how to apply the Group By function in two different ways — one using List.Distinct and the other using Table.Distinct.

Download Excel File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQC9TWS1XRbKQJBL4B_4XhgqAWiCV4TDUWCwn-xE4Tu0MLc?e=7FAv6d

LinkedIn Post:
https://lnkd.in/gEd9ZSnd

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

The next will be Solution to Eleventh (11th) Challenge with Excel 365 Dynamic Array Formulas

I appreciate your understanding of any mistakes I made—please focus on learning and enjoy the video.

Please follow our Social Media:
https://www.linkedin.com/in/shahalam-analytics-excelbi/
https://www.facebook.com/ShahAlamDataTrainingAnalytics/
https://www.shahalamanalytics.com/

@ShahAlamAnalytics | Md Shah Alam | Microsoft Certified Trainer | Excel | Power BI

Видео Solution to Challenge-10 | Power Query M | Unique Combination| Groupby|List.Distinct| Table.Distinct канала ShahAlam: Data Training & Analytics