Count by created date using date condition

[Sams11]

I have a situation like following,  kindly help.

Id

Created date

Sprint start date

Sprint end date

Required query:

How many tickets created using created date between sprint start and end date?

[Anonymous · Accepted solution]

Hi @Sams11 ，

Please try:

Measure = CALCULATE(COUNTROWS('Table'),'Table'[Created date]>='Table'[Sprint start date]&&'Table'[Created date]<='Table'[Sprint end date])

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[ChielFaber]

Could you please provide sample data? This might be just a simple text table with dummy data.

Without any data my 2 cents would be to just use the Group by function in the UI and count the numbers of ID's

When clicking the Group by function chose advanced. You can then select multiple columns to group by. When you select sprint startdate and sprint enddate as the columns to group the data by you can then select count (id) as an aggregation column.

I took a shortcut here by thinking the sprint startdate and enddate are the same for the multiple records (static data) and don't alter per creation date.