cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

## Count of Items Due in Next 30 Days Measure

Good Morning,

I am having trouble with what is probaly an easy measure.   Here is a sample of the data I am using

I want a measure that returns me the count of all the movies that release in the next 30 days

The expected output would be 3 because A, B and C all release in the next 30 days.

I have tried several things but keep getting errors....

Can anyone assist?

Thanks

Kyle

1 ACCEPTED SOLUTION
Community Champion

Hi @juncco888 ,

You can create a measure like below and use it as filter on table or you can directly use to take a count:-

``````measure =
COUNTROWS (
FILTER (
'Table (9)',
DATEDIFF ( TODAY (), 'Table (9)'[Release date], DAY ) < 30
)
)``````

Output:-

Thanks,

Samarth

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Champion

Hi @juncco888 ,

You can create a measure like below and use it as filter on table or you can directly use to take a count:-

``````measure =
COUNTROWS (
FILTER (
'Table (9)',
DATEDIFF ( TODAY (), 'Table (9)'[Release date], DAY ) < 30
)
)``````

Output:-

Thanks,

Samarth

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Thanks this worked great.  I appreciae your assistance.

Super User

``````Count over 30 days =
SUMX (
Table,
VAR __Days = DATEDIFF ( Today(), Table[Release Date], DAY )
RETURN IF ( __Days > 30, 1 )
)``````

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

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.

Thank you.  This also worked well.  I appreciate you taking the time to help!

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors