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.
Hi All,
I've below expression and first one works fine but second one giveing balnk values.
Could you please help me understand what is wrong in second expression.
Total Opportunities = COUNT(Opportunities[TOTALOPPORTUNITYQUANTITY]) - Fine
Funnel additions YTD to plan = TOTALYTD([Total Opportunities],'Calendar'[Date]) - Issue
Basically I need to show all the opportunities which are created from 1st Jan to till date.
Regards,
Viresh
Solved! Go to Solution.
Hi @Anonymous
If you'd like to show all the opportunities which are created from 1st Jan(today's year first date) to till date(today).
Create measures
Total Opportunities = COUNT(Sheet4[TOTALOPPORTUNITYQUANTITY]) Funnel additions YTD to plan = CALCULATE([Total Opportunities],DATESBETWEEN('calendar'[Date],DATE(YEAR(TODAY()),1,1),TODAY()))
Hi @Anonymous
If you'd like to show all the opportunities which are created from 1st Jan(today's year first date) to till date(today).
Create measures
Total Opportunities = COUNT(Sheet4[TOTALOPPORTUNITYQUANTITY]) Funnel additions YTD to plan = CALCULATE([Total Opportunities],DATESBETWEEN('calendar'[Date],DATE(YEAR(TODAY()),1,1),TODAY()))
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |