Solved: how can I count rows by time and category.

Pobthams · ‎08-23-2021

According to the image, I want to create a column that shows the number of previous orders. The orders have to be counted separately by store and reset every day.

amitchandak · ‎08-23-2021

@Pobthams , Create a new column like

countx(filter(Table, [Store] = earlier([Store]) && [date] = earlier([Date]) && [time] < earlier([Time])),[Time])+0

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎08-23-2021

@Pobthams , Create a new column like

countx(filter(Table, [Store] = earlier([Store]) && [date] = earlier([Date]) && [time] < earlier([Time])),[Time])+0

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Pobthams · ‎09-02-2021

@amitchandak What if I want to count orders between 3 PM from the day before until the latest order, and reset every day at 3 PM.

how can I count rows by time and category.

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

How to Get Your Question Answered Quickly

Be one of the first to start using Fabric Databases.