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

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