topic Re: Counting values using EDATE in DAX Commands and Tips

Counting values using EDATE

cpatterson — Fri, 19 Jul 2019 18:27:34 GMT

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.

Re: Counting values using EDATE

parry2k — Mon, 22 Jul 2019 15:38:24 GMT

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

Re: Counting values using EDATE

cpatterson — Mon, 22 Jul 2019 15:43:29 GMT

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.

Re: Counting values using EDATE

parry2k — Mon, 22 Jul 2019 15:58:25 GMT

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.

Re: Counting values using EDATE

cpatterson — Mon, 22 Jul 2019 16:01:35 GMT

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.

Re: Counting values using EDATE

parry2k — Mon, 22 Jul 2019 16:12:00 GMT

good idea Thanks for the suggestion.

Re: Counting values using EDATE

cpatterson — Thu, 25 Jul 2019 18:11:29 GMT

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