Log In
Register
Home
August 4, 2020
Offline
I'd like to added a column onto an existing query that counts the number of rows which have that values in several columns but i'm unsure how I would go about achieving this.
I've put together a sample table of how i'd like it to output. In the sample file the Date, Time and Type column would be checked to see if they have identical values while ignoring the Ref column.
Thanks in advance.
See Answer
July 16, 2010
Offline
Answers Post
August 4, 2020
Offline
Hi Mynda,
I tried your suggestion and it works well to return an incremental count within each group which will be really useful for me.
I managed to figure out that I could also return the total count from each group by creating a custom column and using "= Table.RowCount([Count])" before expanding the tables.
Thank you very much for the help.
The following users say thank you to Richard K for this useful post:
Mynda Treacy
1 Guest(s)
