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 )

    )

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago
var dt = max( DimDate[Date] )
return
CALCULATE(
    SUM(Fact[SALES]),
    KEEPFILTERS( DATESBETWEEN( DimDate[Date], EOMONTH( dt, -1) + 1, dt ), dt ) )
)
Midway's avatar
Midway
Icon for Helper I rankHelper I
1 year ago

hey there, thanks for replying to my post. I tried this formula but it's giving an error, "unexpected parameter , dt". If I remove runs fine but still does not work. Still no sales without selecting any data points.

  • Deku's avatar
    Deku
    Icon for Super User rankSuper User
    1 year ago

    Where is it complaining?

    • Deku's avatar
      Deku
      Icon for Super User rankSuper User
      1 year ago

      Updated

      var dt = MAX( DimDate[Date] )
return
CALCULATE(
    SUM(Fact[SALES]),
    DATESBETWEEN( DimDate[Date], EOMONTH( dt, -1) + 1, dt )
)
      • Midway's avatar
        Midway
        Icon for Helper I rankHelper I
        1 year ago

        it works when selecting any month but it's not defaulting to show current month sales when there is no selection.