https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2511612#M69684 <P>I want to count the number of rows of data entry that occured yesterday. Having the hardest time. I have a date column</P> Thu, 12 May 2022 22:10:59 GMT Yink88 2022-05-12T22:10:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2511612#M69684 <P>I want to count the number of rows of data entry that occured yesterday. Having the hardest time. I have a date column</P> Thu, 12 May 2022 22:10:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2511612#M69684 Yink88 2022-05-12T22:10:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2511829#M69690 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="389384" data-lia-user-login="Yink88" class="lia-mention lia-mention-user">Yink88</a> , if this is not a case of snapshot. Then using the required date </P> <P>&nbsp;</P> <P>countrows(filter(Table, Table[created date] = today()-1) )</P> Fri, 13 May 2022 01:31:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2511829#M69690 amitchandak 2022-05-13T01:31:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2513587#M69790 <P>Thank you so much! It worked! I have another question.</P><P>I have a text column with call locations and I am trying display the text of the location that gets the most calls. How do I do that?</P> Fri, 13 May 2022 13:24:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-Count-mixed-with-date/m-p/2513587#M69790 Yink88 2022-05-13T13:24:10Z