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

This method does not work as the specified client made the payment in October, and before that in August

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



    help please, in the case when I put 1, then he counts the previous month, when 0 does not see it, but when choosing another client at 0 he sees the previous month, and at 1 not, how to fix it?

     

    Prev last MTD Sales = CALCULATE (SUM ('Добавить1'[Количество изделий всего, шт]), FILTER(ALL('Добавить1'[Дата выдачи]),EOMONTH('Добавить1'[Дата выдачи],0)=EOMONTH(CALCULATE(MAX('Добавить1'[Дата выдачи]),FILTER(ALL('Добавить1'[Дата выдачи]),'Добавить1'[Дата выдачи]<max('Добавить1'[Дата выдачи]))),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