Solution to Challenge-9 | Power Query M Code | Group by| Table.SelectRows

Solution to Ninth (9th) Challenge with Power Query M Code

In this video, I present my Solution to Challenge-9 using Power Query M Code.

The task is to calculate cumulative memo counts for each outlet using two different logical methods.

🔹 First Method:
Used the GroupBy function in Power Query to generate a Group Serial Number (SL No.) efficiently.

🔹 Second Method:
Applied Table.SelectRows with a declared row variable — comparing inside columns with outside columns to filter rows having the same Order Date and OutletCode as the current row.

In this method, I also demonstrate how to reference both columns and rows from a sub-table.

Download Excel File:
https://shorturl.at/41By4

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

Download Free eBook:
https://www.dikkhabd.com/newsletter/e...

The next will be Solution to Tenth (10th) Challenge with Excel Power Query M Code

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

Please follow our Social Media:
  / shahalam-analytics-excelbi  
  / shahalamdatatraininganalytics  
https://www.shahalamanalytics.com/

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