Counting values using EDATE

[cpatterson]

Hello,

I'm trying to count the number of values that fall in to a specific date range.. Anytime I use the EDATE function, it won't allow me to choose the column that has my dates in it, even though they're formatted as dates. To be honest, I don't know if I'm using the correct formula, but this is what I tried... but it says my syntax is incorrect. I am still learning DAX and can't seem to get it right.

Measure = CALCULATE(EDATE('Exhibition Reel by LP'[Subscription Date],6)),FILTER('Exhibition Reel by LP','Exhibition Reel by LP'[Learning Plan Name]="Bronze Reel"))

I have several columns in my table, but the important ones are "Subscription Date" and "Learning Plan Name" in this case. Everyone has a date in "Subscription Date" (formatted as a date) and varying text values in "Learning Plan Name." The Learning Plan Name in question is called "Bronze Reel" and a person has 6 months from their Subscription Date to complete this. I would like to count how many Subscription Dates are within 6 months, if the Learning Plan Name is "Bronze Reel." 

Thanks in advance for any advice.

[cpatterson · Accepted solution]

I've solved this. Simply needed to CALCULATE(COUNTROWS( and add FILTER for the things I needed

[parry2k]

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[cpatterson]

If there's something specific you think I'm missing, please let me know. I've already made a few posts on here, in similar format to this, and have had no issue getting results.

[parry2k]

@cpatterson sorry to me your question is not very clear and that's why I shared that post. May be someone else can help who understood what you are asking. 

[cpatterson]

I feel like it's probably more helpful and easier to ask about what you don't understand than posting a link about "how to get replies" but to each their own.

[parry2k]

good idea Thanks for the suggestion.