Hi, I am looking to create a report based off of some API data I am grabbing, the only issue is that it has to be based per day. I am looking to create a column that uses the dates from DateTimeFilter to count the amount of rows/entries with the same date in StartTime. I would also need a column that counts the distinct users on that day too. Does anyone have any tips to get started?
Hi @ppng222
You can first add a Start Date column from StartTime in the same table. Then create a relationship from Date table [DateTimeFilter] to this [Start Date].
Then create the following measures. Use them in a visual along with DateTimeFilter column.
Measure 1 = COUNTROWS('Table')Measure 2 = DISTINCTCOUNT('Table'[UserUuid])
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @ppng222
You can first add a Start Date column from StartTime in the same table. Then create a relationship from Date table [DateTimeFilter] to this [Start Date].
Then create the following measures. Use them in a visual along with DateTimeFilter column.
Measure 1 = COUNTROWS('Table')Measure 2 = DISTINCTCOUNT('Table'[UserUuid])
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
