Hello,
I want to count occurences in the 'Count' column as shown on the attached image. First row is 2 because there are two "Jan" month and "A" entity on the same row.
I hope it's clear (english is not my mother tongue).
Thanks in advance.
Daniel
Counting duplicates in a calculated column
Counting duplicates in a calculated column
- Attachments
-
- IMG.png (13.24 KiB) Viewed 123 times
Re: Counting duplicates in a calculated column
=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[f1]=EARLIER(Table1[f1]) && Table1[f2]=EARLIER(Table1[f2])))
Who is online
Users browsing this forum: No registered users and 5 guests


