Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Using CountIF and date range

(1) ShareShare
ReportReport
Posted on by 101
I have a simple gallery in PowerApps that counts the number of request status that equal the distinct list of those same statuses.
 
For example:
 
On Hold - 23
In Progress - 65
Request Completed - 170
 
This is the formula for the text field in my gallery that displays the value: 
 
Items Property for Gallery: 
Distinct(SVMRequests, 'Req Status')
 
Status Count Value Text Field:
CountIf(SVMRequests, 'Req Status' = lblreqstatus.Text)
 
I'd like help to update the formula so it counts only request statuses with a created date between 12 months ago and Today() instead of counting all of the rows in my dataverse table.
 
Thanks!!
  • WarrenBelz Profile Picture
    WarrenBelz 145,422 on at
    Using CountIF and date range
    A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee
  • WarrenBelz Profile Picture
    WarrenBelz 145,422 on at
    Using CountIF and date range
    Probably something like this
    Distinct(
       Filter(
          SVMRequests, 
          CreatedOn > DateAdd(Today(), -365, Days)
       ),
       'Req Status'
    )
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn   
    Buy me a coffee

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard