Filter Rows based on Date Column

[ppng222]

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?

[v-jingzhang · Accepted solution]

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.