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
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
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.
