Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
koogie
Regular Visitor

Inquiry about M code operation.

Hello.

I am wondering how the M code works. The code is as follows.

1. Each Table.RowCount (Table.SelectRows (# "Grouped Rows", (s) => s [TotalSales]> [TotalSales])) + 1, Int64.Type)

(s) => s [TotalSales]> [TotalSales])) + 1

I'm not sure, but in this formula, s [TotalSales] seems to work for multiple lines. [TotalSales] seems to work on a single row.

2. (s) => Table.RowCount (Table.SelectRows (# "Grouped Rows", each s [TotalSales] <[TotalSales])) + 1, Int64.Type)

Unlike number 1, in this formula, s [TotalSales] seems to act as a single row and [TotalSales] acts as multiple rows.
I'm curious about the difference between the two functions and how they work internally.
1 ACCEPTED SOLUTION
Anonymous
Not applicable

... 
each Table.RowCount (Table.SelectRows (# "Grouped Rows", (s) => s [TotalSales]> [TotalSales])) + 1, Int64.Type)

...

 

this piece of code appears to be part (argument) of a function such as Table.AddColumn or similar.

the inner part of this piece: Table.SelectRows (# "Grouped Rows", (s) => s [TotalSales]> [TotalSales])

selects all rows of the # "Grouped Rows" table (which was probably created in the previous step) that satisfy the condition that the value of column s[TotalSales] is greater than the value _ [TotalSales] of the current row to which the anonymous function each (these selected lines are then counted +1)

 

the following  is an equivalente form of the same expression:

... 
(outer) => Table.RowCount (Table.SelectRows (# "Grouped Rows", (inner) => inner[TotalSales]> outer[TotalSales])) + 1, Int64.Type)

...

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

... 
each Table.RowCount (Table.SelectRows (# "Grouped Rows", (s) => s [TotalSales]> [TotalSales])) + 1, Int64.Type)

...

 

this piece of code appears to be part (argument) of a function such as Table.AddColumn or similar.

the inner part of this piece: Table.SelectRows (# "Grouped Rows", (s) => s [TotalSales]> [TotalSales])

selects all rows of the # "Grouped Rows" table (which was probably created in the previous step) that satisfy the condition that the value of column s[TotalSales] is greater than the value _ [TotalSales] of the current row to which the anonymous function each (these selected lines are then counted +1)

 

the following  is an equivalente form of the same expression:

... 
(outer) => Table.RowCount (Table.SelectRows (# "Grouped Rows", (inner) => inner[TotalSales]> outer[TotalSales])) + 1, Int64.Type)

...

 

Thank you very much.

Thanks to that, it was well understood.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors