User Profile
mvgust
Helper III
Joined 6 years ago
User Widgets
Contributions
Why would group by be filtering out records
I've got a table with 2.4 million records. I'm running into a situation where when using the group by function, it's incorrectly filtering out records. I've got timecard records, and I'm looking to obtain the min time value for a day, pretty basic group by function. Below is an example. If I pre-filter the data to a particular record id, it will complete the group by on that record without issues. So I know the record exists, and the group by function can obtain the min time value for a days. However, when I move the filter to below the group by (to ensure that record is in my recordset) the record doesn't exist after the group by. Any idea why this would be happening? This record should be included in my grouped by dataset. Below is the complete M code in case I've missed something obvious as to why the record isn't there. let Source = #"TIS TIS_1448_TIMECARDSAVELOG", #"Grouped Rows" = Table.Group(Source, {"Tcid", "Date"}, {{"Min", each List.Min([Time]), type time}}), #"Filtered Rows" = Table.SelectRows(#"Grouped Rows", each [Tcid] = 8592184) in #"Filtered Rows" Thank you.
