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 , You have to try like

 

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

 

previous month value = CALCULATE(sum('Table'[total hours value]),previousmonth('Date'[Date]))

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