Count of Items Due in Next 30 Days Measure

[juncco888]

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

[Samarth_18 · Accepted solution]

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

[juncco888]

Thanks this worked great.  I appreciae your assistance.

[parry2k]

@juncco888 add a measure :

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

✨ Follow us on LinkedIn and  to our YouTube channel

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.

[juncco888]

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