
Catalin Bombea
Iasi, Romania
Admin

Forum Posts: 1844
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: Marcel Bila, Nicholas Meyer, Andrew Mansour, Sheryl Gill, Rob Starren, Leigh Thomas
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28551
Member Stats:
Guest Posters: 49
Members: 32804
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
