Counter that has same value for each day

[Anonymous]

Hi there!

I need a column as shown below:

time	Day	Counter	index
11/6/2018 21:00	6	1	1
11/6/2018 22:00	6	1	2
11/6/2018 23:00	6	1	3
11/7/2018 0:00	7	2	4
11/7/2018 1:00	7	2	5
11/7/2018 2:00	7	2	6
11/7/2018 3:00	7	2	7
12/6/2018 3:00	6	3	8
12/7/2018 3:00	7	4	9

This counter would assign the same count to each hour of the day. The column should output the same as the sample data as a test.

Any thoughts?

thanks!

[AlB]

Hi @Anonymous

So you mean Counter has one value per day, regardless of the time, and that value is unique for each day. Correct?

Where does the 1 start? Or can it be any number as long as they are unique per day?

[Zubair_Muhammad · Accepted solution]

@Anonymous @AlB

i think a RANKX function by date might do the job

Column =
RANKX ( Table1, Table1[time].[Date],, ASC, DENSE )