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.

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))