
Catalin Bombea
Iasi, Romania
Admin

Forum Posts: 1810
Member Since:
November 8, 2013
November 8, 2013

Group By, this is the answer.
Choose the grouping keys, then For the first column that will be added, choose Sum for the Balance column as aggregator. For the second column, use whatever aggregation works best for you: Min, Max, Average.
If none is usable, simply do not aggregate, you have the option to return all rows. This action will return a table of results in this column. Next, you can write a simple formula in a new column to return the first item in this table:
=[AllRowsColumn][Price]{0}
In the same manner, you can return the last item in that table of results: [AllRosColumn][Price]{List.Count([AllRowsColumn][Price])}
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kim Knox
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Raj Mattoo
Mark Luke
terimeri dooriyan
Forum Stats:
Groups: 3
Forums: 24
Topics: 6221
Posts: 27285
Member Stats:
Guest Posters: 49
Members: 31909
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
