https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker Dan_Crowther1 Tracker Sat, 05 Sep 2026 05:27:45 GMT 2026-09-05T05:27:45Z https://community.fabric.microsoft.com/t5/Desktop/Events-In-Progress-How-to-show-visual-List-of-active-records/m-p/3357424#M1118757 <P>Hi, i hope someone can help with this 'Events in Progress' query,</P><P>&nbsp;</P><P>I have been able to create a measure which calculates the number of records which are active during a 'MIN Date &amp; MAX date of the selected calendar table. But what i am looking to show is a visual list (using the 'Table' visual) of the actual records which make up the calculated total during a selected date period...i.e. if i select July 2023, then i want to see all the records that were active during July 2023.&nbsp;</P><P>The problem i have is that the only relationship i have between the Calendar Table and the 'Fact Table' is a start date and end date columns which derives the data about if the record is active or not. But when i want to show a list of active records, it will only show the records which have either started or ended during the selected period, and not records which were just active during the selected period</P><P>&nbsp;</P><P>Can anyone help with how i go about this request?</P><P>&nbsp;</P><P>Many thanks</P><P>Dan</P> Mon, 31 Jul 2023 07:42:59 GMT https://community.fabric.microsoft.com/t5/Desktop/Events-In-Progress-How-to-show-visual-List-of-active-records/m-p/3357424#M1118757 Dan_Crowther1 2023-07-31T07:42:59Z