Forum Discussion

CJANE's avatar
CJANE
Helper I
8 years ago
Solved

Current and Previous MTD Calculation

Hello:   Any recommendations from the community on how I can update the expression below so prior year MTD only includes 10/01/2016 through 10/16/2016.  Currently the measure is returning the sum f...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    CJANE,

     

    Add a calendar table and build relationship.

    Measure =
TOTALMTD (
    SUM ( PrimaryTrades[GrossAmountOffer] ),
    DATEADD ( DATESMTD ( 'Calendar'[Date] ), -1, YEAR )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

CJANE,

 

Add a calendar table and build relationship.

Measure =
TOTALMTD (
    SUM ( PrimaryTrades[GrossAmountOffer] ),
    DATEADD ( DATESMTD ( 'Calendar'[Date] ), -1, YEAR )
)