How to perform following "Group by" expression

[CHUN KIT LEE]

Hi everyone,

I want to add a calculated column that count the records by [Date], for example :

Table t1:

Date | Calculated column

--------------------------------------------------

27/07/2021 | 2

27/07/2021 | 2

28/07/2021 | 1

29/07/2021 | 3

29/07/2021 | 3

29/07/2021 | 3

--------------------------------------------------

Can someone please tell me what should my expression be

Thanks.

[Fabian Duerr]

You want to count in the [Date] column and aggregate by the same column:

Count([Date]) over [Date] or

Count() over [Date]

[CHUN KIT LEE]

It works! Thank you.

 

What if I want to group by two columns, should it be :

 

Count() over [Col_A] and [Col_B]

[Fabian Duerr]

Please try:

 

Count() over ([Col_A],[Col_B])