Forum Discussion

cpatterson's avatar
cpatterson
Helper I
7 years ago
Solved

Counting values using EDATE

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.

 

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

6 Replies