topic counting rows on the date column where the time &gt; 5:30 pm in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401618#M128462 <P>how can i&nbsp;<SPAN>counting rows on the date column where the time &gt; 5:30 pm</SPAN></P> Mon, 28 Aug 2023 06:40:12 GMT waleed55 2023-08-28T06:40:12Z counting rows on the date column where the time > 5:30 pm https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401618#M128462 <P>how can i&nbsp;<SPAN>counting rows on the date column where the time &gt; 5:30 pm</SPAN></P> Mon, 28 Aug 2023 06:40:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401618#M128462 waleed55 2023-08-28T06:40:12Z Re: counting rows on the date column where the time > 5:30 pm https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401676#M128466 <P>I think you have a time column in your date table. You can do this with the measure below:</P><P>&nbsp;</P><LI-CODE lang="markup"># minutes after 0530 = CALCULATE( COUNTA(DateTable[TimeStamp]) ,FILTER(DateTable, DateTable[TimeStamp] &gt; TIME(05,30,0)) )</LI-CODE> Mon, 28 Aug 2023 07:06:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401676#M128466 _halim 2023-08-28T07:06:18Z Re: counting rows on the date column where the time > 5:30 pm https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401745#M128469 <P>your code not work</P> Mon, 28 Aug 2023 07:51:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/counting-rows-on-the-date-column-where-the-time-gt-5-30-pm/m-p/3401745#M128469 waleed55 2023-08-28T07:51:20Z