Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
I've solved this. Simply needed to CALCULATE(COUNTROWS( and add FILTER for the things I needed
I've solved this. Simply needed to CALCULATE(COUNTROWS( and add FILTER for the things I needed
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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
good idea Thanks for the suggestion.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |