Forum Discussion

Eriko's avatar
Eriko
Frequent Visitor
11 years ago
Solved

Calculate the month-over-month

Hello.   There are a table "Sales" and a table "Date".   I want to do is the following.   1. Outputs Sales Amount of every month. 2. Calculate the month-over-month.   I referenced this site,...
Need Help
  • procyon82's avatar
    procyon82
    11 years ago

    Just tried something like this which gives me the previous month

     

    Previous month = CALCULATE(SUM('GA Ecommerce'[Sales]),PREVIOUSMONTH('GA Ecommerce'[Date]))

    or

    Previous Month = CALCULATE(SUM('GA Ecommerce'[Sales]),DATEADD('GA Ecommerce'[Date],-1,MONTH))

     

    Should be pretty easy to do MOM from this.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 years ago

Can you post some sample data and your formula. From your error, it looks like one of your functions is returning a table when a single column is expected, or something along those lines.

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
11 years ago

Just tried something like this which gives me the previous month

 

Previous month = CALCULATE(SUM('GA Ecommerce'[Sales]),PREVIOUSMONTH('GA Ecommerce'[Date]))

or

Previous Month = CALCULATE(SUM('GA Ecommerce'[Sales]),DATEADD('GA Ecommerce'[Date],-1,MONTH))

 

Should be pretty easy to do MOM from this.