title: Months To date formula not working properly on Power Bi
body: <p>I am newbie in Power Bi. I am calculating months to date of a measure.</p>
  
  <p>I have written following DAX formula for that,</p>
  
  <p><code>MTD in Sales = CALCULATE([Total Sales], DATESMTD(Dates[Date]) )</code></p>
  
  <p>it shows me correct total sales value of this month.But when i make day-wise, it shows me some unrealistic value.<a href="https://i.stack.imgur.com/sVYBQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sVYBQ.png" alt="enter image description here"></a> </p>
  
  <p>I have attached a screenshots of my result..Please have a look.</p>
  
  <p>I don't understand what wrong are going on? Can you please find out the problem plz?</p>