Getting blank values while calculating YTD data

[Anonymous]

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

[v-juanli-msft · Accepted 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()))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.