Row count per day per employee

[Anonymous]

Hi all,

I have the following issue:

 

For each date and employee I want a row count. (see picture) (Employee A has 2 rows on 1-1-2018 so I expect 2 as a result, etc) The column 'rowcount per employee' is the exact result I want.    

How do I fix this in Power Bi?  

[petrovnikitamai]

if i understand u

try this

new column = countrows(filter(tableName;earlier([Date])=[Date]&&earlier([employee])=[employee]))

[Anonymous · Accepted solution]

Hi, already solved with another solution. I made a 'group by' in my dataset.  Thnx for your help.