Log In
Register
Home
December 4, 2021
Offline
I have a sheet/query named "WSCoreTeam". Column B contains email addresses and Column G contains an index (beginning at 1). Currently there are 3,853 records on this sheet. I would like to create a new column (Column H) as "Max Count". I cannot figure out how to do what I want. I would like this new column to look at the Index, and then create Groups, for example Index (Column H) 1-500 would ALL display as Group 1 (or Group A), then Index 501-1000 would display as Group 2 (or Group B). This process would continue until all records had a group. As there are 3,853 current records there would be 8 groups, however the final group would be less than the max of 500 records. There are no corresponding groups that this count relates to, it is completely unrelated from everything else. Thanks in advance!
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Perhaps the easiest would be to use Table.Split and cut up the larger table into ones with 500 rows. This creates a list of tables, each 500 rows large and the last one contains whatever number of rows are left. Then convert the list to a table, add an index from one and expand. See the attached file for an example.
1 Guest(s)
