Forum Discussion

Sams11's avatar
Sams11
Frequent Visitor
2 years ago
Solved

Count by created date using date condition

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
ChielFaber
Super User
2 years ago

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.