Forum Discussion

snandy2011's avatar
snandy2011
Helper IV
8 years ago
Solved

DAX : Month To date formula help

  Hi, Everyone,   I have created a moth to date measure by following formula   MTD = CALCULATE(SUM('Poker Profit'[Gross Gaming Revenue]), DATESMTD('Calendar'[Date]))    It is showing me the co...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi @

     

    What happens when you use your 'Calendar'[Date] field on a visual with your calculated measure.  It seems strange to use it with a Week Day Name field.  MTD functions will try to cumulate your measure up over the days of the calendar month.

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi snandy2011

 

That's the way the MTD function works.  For whatever day on whatever month you pass to it, it will return what the cumulative value of the measure is to that day of that month.

 

If you only want to show data for June, then use a slicer to filter on June so that only those days appear on the axis.  This is by design and is actually quite useful.

snandy2011's avatar
snandy2011
Helper IV
8 years ago

Hi Phil_Seamark sir,

 

Thanks for teaching me a wonderful concept. I had completely wrong idea about Month to date. It gives us cumulative total or running total of that particular month whatever month i am passing. I need to clear this concept more.

 

Thanks for this lesson.It was great learning.

 

Thanks,

snandy2011