Forum Discussion

Niels_T's avatar
Niels_T
Post Patron
4 years ago
Solved

MTD Previous month

Hello,   I have a MTD measure that goes as followed:   Quantity (base) MTD = IF ( MIN ( 'Calendar'[Date] ) <= CALCULATE ( MAX ( 'Calendar'[Date]), ALL ( 'Returns') ), CALCULATE ( SUM ( 'Return...
Need Help
  • Niels_T's avatar
    Niels_T
    4 years ago

    Hello,

     

    I've fixed the issue!


    I used the following DAX measure:

     

    Quantity (base) Last Month MTD = IF (
    MIN ( 'Calendar'[Date] ) <= CALCULATE ( MAX ( 'Calendar'[Date]), ALL ( 'Returns') ),
    CALCULATE ( SUM ( 'Returns'[quantity (base)]), DATESMTD (DATEADD('Calendar'[Date], -1, MONTH )
    )))
Niels_T's avatar
Niels_T
Post Patron
4 years ago

Hello,

 

I've fixed the issue!


I used the following DAX measure:

 

Quantity (base) Last Month MTD = IF (
MIN ( 'Calendar'[Date] ) <= CALCULATE ( MAX ( 'Calendar'[Date]), ALL ( 'Returns') ),
CALCULATE ( SUM ( 'Returns'[quantity (base)]), DATESMTD (DATEADD('Calendar'[Date], -1, MONTH )
)))