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