Forum Discussion

Midway's avatar
Midway
Icon for Helper I rankHelper I
1 year ago
Solved

help with DAX MTD

Hi there,  I'm really struggling with this calculation with this DAX measure; What I need to accomplish is show let's sales numbers in a card. When a month is selected in another visual (like a time...
  • Deku's avatar
    Deku
    1 year ago

    var dt = eomonth( MAXX( summarize( fact, DimDate[Date] ), dimdate[date]), 0)

    return

    CALCULATE(

        SUM(Fact[SALES]),

        DATESBETWEEN( DimDate[Date], EOMONTH( dt, -1) + 1, dt )

    )

techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi Midway please check this

 

ResultMeasure=

VAR IsMonthSelected = ISFILTERED('DATE'[Month])

VAR DefaultMonthSales =
CALCULATE(
SUM('sheet1'[enrollment amount]),
FILTER(
ALL('DATE'),
'DATE'[Year] = YEAR(TODAY()) && 'DATE'[Month] = MONTH(TODAY())
)
)

VAR SelectedMonthSales =
CALCULATE(
SUM('sheet1'[enrollment amount]),
DATESMTD('DATE'[Date])
)

RETURN
IF(
IsMonthSelected,
SelectedMonthSales,
DefaultMonthSales
)

Midway's avatar
Midway
Icon for Helper I rankHelper I
1 year ago

Thanks for replying to my post, this gets the default sales numbers for the current month when no selection has been made, but it keeps the same current month sales numbers when selecting other months.