Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dk6569
Helper I
Helper I

Count with filters after a date

I have been trying different ways to get the data I need with no success so hoping someone out here can help me. I'm trying to create a few measures that I can put into a graph. In summary I need to count the number of Projects for each color , step that are after 4/1/2022.  Below is an example table and the exected results table below it.

 

Proj #Step StatusColorDate
363040CloseYellow3/18/22
373914ETJRed4/29/22
376363ETJRed5/27/22
373913ETJYellow2/5/22
379054ETJYellow6/10/22
378473CloseRed8/7/22
340188CloseYellow8/14/22
339964CloseYellow6/9/22

352304

ETJRed4/30/22

353587

CloseRed7/31/22

 

Expected Results: Row 1 & 4 would not be part of the calculation since they are before 4/1/2022

ColorStepCount
RedETJ3
RedClose2
YellowETJ1
YellowClose2

Thank you,

dk6569

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@dk6569 add following measure:

 

Count = 
CALCULATE ( 
   COUNTROWS ( Table ),
   Table[Date] >= DATE ( 2022,4,1 )
)

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

1 REPLY 1
parry2k
Super User
Super User

@dk6569 add following measure:

 

Count = 
CALCULATE ( 
   COUNTROWS ( Table ),
   Table[Date] >= DATE ( 2022,4,1 )
)

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.