My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Running totals for the bottom 12 rows groups by employee|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Running totals for the bottom 12 rows groups by employee|Power Query|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Running totals for the bottom 12 rows groups by employee
Avatar
Martyn Cheney

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
August 19, 2022
sp_UserOfflineSmall Offline
1
August 19, 2022 - 1:57 am
sp_Permalink sp_Print

Hello 

Hello i have a spreadshet/power query data 

and I need to somehow total the first 12 rows for each person in the query, I've tried various date based formula but because the dates are sequential it doesn't seem to want to work, so now, I'm thinking that its best to do 12 rows.

There are 104 employees in my data set with varying number of rows per person, from 1 up to 28 

 

any ideas?  I'm lost with it.

Sample Data

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members


Trusted Members

Moderators

Power BI
Level 0
Forum Posts: 492
Member Since:
January 31, 2022
sp_UserOfflineSmall Offline
2
August 19, 2022 - 2:24 am
sp_Permalink sp_Print

Hi Martyn,

Can you please attach a file, rather than a picture via Dropbox?

You can group by ID and add a custom column keeping the first 12 rows of each of the nested tables in the grouped column. Easiest to demonstrate on a file with your own data.

Riny

Avatar
Martyn Cheney

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
August 19, 2022
sp_UserOfflineSmall Offline
3
August 19, 2022 - 4:13 pm
sp_Permalink sp_Print

heres a sample of the data

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members


Trusted Members

Moderators

Power BI
Level 0
Forum Posts: 492
Member Since:
January 31, 2022
sp_UserOfflineSmall Offline
4
August 19, 2022 - 4:57 pm
sp_Permalink sp_Print

Perhaps the attached file contains the PQ solution you need. Otherwise I may have misunderstood.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Aminu Sule
Samuel Ramirez
Abdifatah Osman
mohad borhom
Abayomi Adedeji
Ganesh MVS
Gilbert Lemek
Ashleigh Farquharson
Jayz Luu
Fred Smith
Forum Stats:
Groups: 3
Forums: 24
Topics: 6364
Posts: 27829

 

Member Stats:
Guest Posters: 49
Members: 32346
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen