Forum Discussion
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
- parry2kSuper User
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- cpattersonHelper I
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.
- parry2kSuper User
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.
- cpattersonHelper I
I've solved this. Simply needed to CALCULATE(COUNTROWS( and add FILTER for the things I needed