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 @

 

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.

snandy2011's avatar
snandy2011
Helper IV
8 years ago

Hi Phil_Seamark

 

Thanks for your reply.. It is showing wrong result..

 

 

Please have a look.. It should show only june's value..But it also shows may and other's month value..

  • 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

    • alexis_vasquez's avatar
      alexis_vasquez
      Frequent Visitor
      8 years ago

      hi Phil_Seamark i have a similar question, but MTD function works giving the cumulative values in the month. I have a mtd function but it does not give me the accumulated value of the current month. the function gives the accumalted value of the last month. The correct amount should be 0 to the current month.

      This is my code:

       

      Monto_acumulado_cursesl = TOTALMTD(sum(General[Todo_lo_cursado_monto]);General[Fecha_curse_2];ALLSELECTED(General))