Spreadsheet: 887347d1737579450-power-query-count-only-one-and-earliest-occurrence-per-date-count-one-per-date-test
Sheet: Sheet1

Data |  |  |  |  |  | Needed Result |  |  |  |  |  | My Attempt
Date | Name | Room | Start Time | Count? |  | Date | Name | Room | Start Time | Count? |  | Date | Name | data2.Room | data2.Start Time | Custom
2025-01-02 00:00:00 | [NAME] | rm 01 | 07:30:00 | 1 |  | 2025-01-02 00:00:00 | [NAME] | rm 01 | 07:30:00 | 1 |  | 2025-01-02 00:00:00 | [NAME] | rm 01 | 07:30:00 | 1
2025-01-02 00:00:00 | [NAME] | rm 01 | 09:30:00 | 0 |  | 2025-01-02 00:00:00 | [NAME] | rm 01 | 09:30:00 | 0 |  | 2025-01-02 00:00:00 | [NAME] | rm 01 | 09:30:00 | 0
2025-01-02 00:00:00 | [NAME] | rm 02 | 08:00:00 | 1 |  | 2025-01-02 00:00:00 | [NAME] | rm 02 | 08:00:00 | 0 |  | 2025-01-02 00:00:00 | [NAME] | rm 02 | 08:00:00 | 0 | as intended
2025-01-02 00:00:00 | [NAME] | rm 02 | 10:00:00 | 0 |  | 2025-01-02 00:00:00 | [NAME] | rm 02 | 10:00:00 | 0 |  | 2025-01-02 00:00:00 | [NAME] | rm 02 | 10:00:00 | 0
2025-01-02 00:00:00 | Mark | rm 03 | 07:30:00 | 1 |  | 2025-01-02 00:00:00 | Mark | rm 03 | 07:30:00 | 1 |  | 2025-01-02 00:00:00 | Mark | rm 03 | 07:30:00 | 1
2025-01-02 00:00:00 | Mark | rm 03 | 09:00:00 | 0 |  | 2025-01-02 00:00:00 | Mark | rm 03 | 09:00:00 | 0 |  | 2025-01-02 00:00:00 | Mark | rm 03 | 09:00:00 | 0
2025-01-03 00:00:00 | [NAME] | rm 12 | 08:00:00 | 1 |  | 2025-01-03 00:00:00 | [NAME] | rm 12 | 08:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 12 | 08:00:00 | 1 | counted the later time for this date and person
2025-01-03 00:00:00 | [NAME] | rm 12 | 10:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 12 | 10:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 12 | 10:00:00 | 0
2025-01-03 00:00:00 | [NAME] | rm 12 | 11:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 12 | 11:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 12 | 11:00:00 | 0
2025-01-03 00:00:00 | [NAME] | rm 14 | 07:30:00 | 1 |  | 2025-01-03 00:00:00 | [NAME] | rm 14 | 07:30:00 | 1 |  | 2025-01-03 00:00:00 | [NAME] | rm 14 | 07:30:00 | 0 | should be 1
2025-01-03 00:00:00 | [NAME] | rm 14 | 09:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 14 | 09:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 14 | 09:00:00 | 0
2025-01-03 00:00:00 | [NAME] | rm 15 | 08:00:00 | 1 |  | 2025-01-03 00:00:00 | [NAME] | rm 15 | 08:00:00 | 1 |  | 2025-01-03 00:00:00 | [NAME] | rm 15 | 08:00:00 | 1
2025-01-03 00:00:00 | [NAME] | rm 15 | 09:30:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 15 | 09:30:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 15 | 09:30:00 | 0
2025-01-03 00:00:00 | [NAME] | rm 15 | 12:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 15 | 12:00:00 | 0 |  | 2025-01-03 00:00:00 | [NAME] | rm 15 | 12:00:00 | 0
2025-01-04 00:00:00 | [NAME] | rm 04 | 08:00:00 | 1 |  | 2025-01-04 00:00:00 | [NAME] | rm 04 | 08:00:00 | 0 |  | 2025-01-04 00:00:00 | [NAME] | rm 04 | 08:00:00 | 1 | counted the later time for this date and person
2025-01-04 00:00:00 | [NAME] | rm 04 | 09:00:00 | 0 |  | 2025-01-04 00:00:00 | [NAME] | rm 04 | 09:00:00 | 0 |  | 2025-01-04 00:00:00 | [NAME] | rm 04 | 10:00:00 | 0
2025-01-04 00:00:00 | [NAME] | rm 04 | 10:00:00 | 0 |  | 2025-01-04 00:00:00 | [NAME] | rm 04 | 10:00:00 | 0 |  | 2025-01-04 00:00:00 | [NAME] | rm 04 | 09:00:00 | 0
2025-01-04 00:00:00 | [NAME] | rm 05 | 07:30:00 | 1 |  | 2025-01-04 00:00:00 | [NAME] | rm 05 | 07:30:00 | 1 |  | 2025-01-04 00:00:00 | [NAME] | rm 05 | 07:30:00 | 0 | should be 1
2025-01-04 00:00:00 | Nate | rm 08 | 08:00:00 | 1 |  | 2025-01-04 00:00:00 | Nate | rm 08 | 08:00:00 | 1 |  | 2025-01-04 00:00:00 | Nate | rm 08 | 08:00:00 | 1
2025-01-04 00:00:00 | Nate | rm 08 | 10:00:00 | 0 |  | 2025-01-04 00:00:00 | Nate | rm 08 | 10:00:00 | 0 |  | 2025-01-04 00:00:00 | Nate | rm 08 | 10:00:00 | 0
2025-01-04 00:00:00 | Nate | rm 08 | 12:00:00 | 0 |  | 2025-01-04 00:00:00 | Nate | rm 08 | 12:00:00 | 0 |  | 2025-01-04 00:00:00 | Nate | rm 08 | 12:00:00 | 0