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 date?

Need Help

2 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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