Solved: Row Count mixed with date

Yink88 · ‎05-12-2022

I want to count the number of rows of data entry that occured yesterday. Having the hardest time. I have a date column

amitchandak · ‎05-12-2022

@Yink88 , if this is not a case of snapshot. Then using the required date

countrows(filter(Table, Table[created date] = today()-1) )

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

amitchandak · ‎05-12-2022

@Yink88 , if this is not a case of snapshot. Then using the required date

countrows(filter(Table, Table[created date] = today()-1) )

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Yink88 · ‎05-13-2022

Thank you so much! It worked! I have another question.

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?

Row Count mixed with date