Few types of attendance in the same day per employee

[uda123]

Hi everybody,

I have a table of employees attendance.

I want to know who entered the same entrytype or another combination of type in the same day.

For example I want an alert when an employee used "card" twice in the same day. 

what a dax formula can i use?

The table looks like this:

ID	NAME	DATE	EntryType
1	Dana	01/10/22	card
2	Dana	01/10/22	card
3	Joe	02/10/22	office
4	Joe	02/10/22	web

Thanks 🙂

[v-yalanwu-msft]

Hi， @uda123 ；

You could create a measure as follow:

Measure = 
var _count=CALCULATE(COUNT('Table'[EntryType]),ALLEXCEPT('Table','Table'[NAME],'Table'[DATE],'Table'[EntryType]))
return IF(_count>1,"Red","White")

then setting conditional format.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bifinity_75 · Accepted solution]

Hi @uda123 , try this:

- In Power Query duplicate Date Column as text value:

- Create a custom column in Power Query to concatenate NAME & ENTRYTYPE & DATE (Text copy):

- Create this calculate column:

Count_concat =

VAR CountDistinct = Table_[CONCAT]

RETURN

CALCULATE(

    COUNTROWS(Table_),

    ALL('Table_'),

    Table_[CONCAT] = CountDistinct

)

- Go to conditional formatting select NAME as Serie:

- And apply this rule:

- The result is:

Best regards