Forum Discussion
andersona1983
Helper I
Helper IOverlapping Appoints of a Specific Type
Hello, I am trying to find overlapping appointments of a certain type, on a date, and producing a report of all those appointments that match this. My data comes in the following format: ...
Greg_Deckler
Community Champion
Community Championandersona1983 - You could potentially use a variation of Open Tickets, which is designed to work with date/time intervals.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
In theory, you could count the number of items in each interval and display this count on a column chart. Clicking on any column could filter a table to show you the items that overlap.
andersona1983Helper I
Helper IGreg_Deckler Thanks I will attempt to do this!