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

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

What does ('Table'[total hours value]?

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

DeEviloN , Just a different measure in example ,

 

like

 

MTD = CALCULATE(SUM ('Добавить1'[Количество изделий всего, шт]),DATESMTD('Date'[Date]))
last MTD = CALCULATE(SUM ('Добавить1'[Количество изделий всего, шт]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

 

previous month = CALCULATE(SUM ('Добавить1'[Количество изделий всего, шт]),previousmonth('Date'[Date]))