Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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_...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak 

Yes I have dates for the whole 2020 in the Date table.

It is marked as a date table.

Yes there is data for the period. 

 

One of the measure is working fine through it. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , When you do select a date on you page .

 

 

TOTALMTD(SUM(fLeads[LeadCount]), fLeads[DATE_KEY_LEAD]) . End date of your MTD here is end date of you data coming from transaction table. so you are getting it 
 
TOTALMTD(SUM(fLeads[LeadCount]), dDate[Date]) is not working. End date ne date of calendar which may dec-2020.
 
Go and plot. MTD with date calendar with month year and check. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak 

    I have uploaded a video to youtube.

     

    Youtube_Video - Not the best result but maybe you can slow the video down.

    First I show the result 4. This result works fine with the dDate.

    Yesterday - 1 =CALCULATE( SUM(fLeads[LeadCount]), dDate[Date] = TODAY()-1

    Therefore dDate[Date] and fLeads[DATE_KEY_LEADS] must be the correct format right? Else why would the result not be blank?

     

    After I show CALCULATE(SUM(fLeads[LeadCount]), DATESMTD(dDate[Date])) is not working.

     

    Please help.