Forum Discussion

DeEviloN's avatar
DeEviloN
Icon for Helper III rankHelper III
4 years ago
Solved

PREVIOUSMONTH(DATESMTD

I have a measure that calculates based on the amount for the month of the last sales with the previous month when there were sales   Prev last MTD Sales = CALCULATE (SUM ('Добавить1'[Количество изд...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    DeEviloN ,  Try like

     

    Last Month non Continuous = CALCULATE([sales],filter(ALL('Date'),eomonth('Date'[Date]) =eomonth( CALCUALTE( MAx(Table[Date]), FILTER(ALL('Date'),'Date'[Date]<max('Date'[Date]))),0)))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

DeEviloN ,  Try like

 

Last Month non Continuous = CALCULATE([sales],filter(ALL('Date'),eomonth('Date'[Date]) =eomonth( CALCUALTE( MAx(Table[Date]), FILTER(ALL('Date'),'Date'[Date]<max('Date'[Date]))),0)))

DeEviloN's avatar
DeEviloN
Icon for Helper III rankHelper III
4 years ago

In your case, when you write a formula without specifying the month and close the parentheses, you get an error