Home Forums Power Pivot Previousmonth() accumulated

This topic contains 1 reply, has 1 voice, and was last updated by  Alf 3 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #8204

    Alf
    Participant
    • Started: 3
    • Replies: 6
    • Total: 9

    Hi

     

    I need to track changes in numbers from month to month. As of now i am using calcultate with previousmonth() as filter and everything works great when I have my periods (jan, feb, mar….) on columns in my pivot. But; is there a way, or another formula, that would work if one would want to see it accumulatet. Jan-mars in one column…

     

    Hope this is somewhat understandable…

     

    Br

     

    Alf

    #8205

    Alf
    Participant
    • Started: 3
    • Replies: 6
    • Total: 9

    I figured it out myself 🙂 By using dateadd() instead of previousmonth().

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.