Forum Discussion
SUM MTD Not working through DateTable
Hi, LeadCount MTD = CALCULATE(SUM(fLeads[LeadCount]), DATESMTD(dDate[Date])) is not working But if I do directly LeadCount MTD = CALCULATE(SUM(fLeads[LeadCount]), DATESMTD(fLeads[DATE_KEY_...
Anonymous ,
seems like type mismatch with data tabel and fLeads[DATE_KEY_LEAD],
make sure fLeads[DATE_KEY_LEAD] is type of date.
Hi Anonymous
Seems like it is, right?
Anonymous ,
Seems like not 🙂
Anonymous
Why not?
The field is stated as a date and the Yesterday function is working fine.
Could you please explain what am I missing?