Results 1 to 4 of 4

Thread: Formula Help

  1. #1

    Formula Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm trying to display total sales from the previous month this is the formula i used:

    PriorMonth:=CALCULATE(SUM(DATA[NonTaxableSalesAmt]),DATESMTD(DATA[InvoiceDate]))

    But it just shows the sales from the current month

    I am using excel 2013 powerpivot.

    What am i doing wrong???

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Is CALCULATE an Excel function?


  3. #3
    Acolyte Weazel's Avatar
    Join Date
    Jul 2014
    Location
    Florida
    Posts
    26
    Articles
    0
    Excel Version
    2016
    Calculate is a DAX function

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    I didn't see this part

    I am using excel 2013 powerpivot
    and I need another coffee


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •