Create a Table for Duplicate Values within Same Day

[ok_kpop]

I want to create a table where it'll show if there are duplicate time intervals within one day. For example, in the current spreadsheet I have loaded into the file attached below, there's (2) 800am intervals in Day 1. 

I want the table to list the day and all the time intervals that are repeated (if there are any). If there's no duplicate time intervals within a day, I want it to just say "No duplicates" :

DUMMY FILE 

[amitchandak · Accepted solution]

@ok_kpop , Create a measure like

Measure =

var _1 = countrows(Table)

return 

if(_1 >1, "duplicates", "No duplicates")

Plot this with day in a visual

[ok_kpop]

Thanks for your help! I do want to add onto this formula and I made another post about it. If you could help me with this as well, I'd really appreciate it! https://community.fabric.microsoft.com/t5/Desktop/Formula-to-Detect-Missing-Time-Intervals-amp-amp-D...