Marking 1st event in day by some condition/s

[al1981]

Dear colleagues

I would kindly ask for help... I have one table with all emplyees, more months. Each line represents event - there can be more lines in same day

I would need to mark/count specific line Business absense which can be find in B column (Type description) but only, if this Business absense is the 1st event in the day (there can be more during the same day)

One option would be with adding Index for each event, but in correlation Type description/date/start time/employee?

Example table is bellow...

[al1981]

Thank you! Helped a lot - very simple but it missed it 🙂

[Anonymous · Accepted solution]

Hi @al1981 ,

About how to add index for groups, please refer to:

Create Row Number for Each Group in Power BI using Power Query - RADACAD

For multiple column grouping, use Ctrl of the keyboard for multi-select and then use "Group by".

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.