Home Forums Power Pivot Show variation in sales as well as Excel

This topic contains 5 replies, has 3 voices, and was last updated by  okat 1 week, 1 day ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #11125

    okat
    Participant
    • Started: 8
    • Replies: 11
    • Total: 19

    Two measures need to be created:
    One that gets the difference in sales of the last month over the previous month, and another, that gets the percentage change of these two months. If I believe these measures, both are repeated in each column of the month. For example, I just need you to calculate the variation between April and March. It is possible to do so, as shown in the spreadsheet, but with measurements?

     

     

    Attachments:
    You must be logged in to view attached files.
    #11127

    okat
    Participant
    • Started: 8
    • Replies: 11
    • Total: 19
    Image 2018-11-06 at 9.52.34 AM.png
    #11130

    stasinek
    Participant
    • Started: 3
    • Replies: 10
    • Total: 13

    My suggestion in the attachment. See if it’s good?

    Attachments:
    You must be logged in to view attached files.
    #11135

    DaxOnaBoat
    Participant
    • Started: 1
    • Replies: 5
    • Total: 6

    The greatest formula in the world can solve this issue!

    https://powerpivotpro.com/2011/12/the-greatest-formula-in-the-world-part-one/

    It’s a bit overkill for this issue though, Dateadd (or parallelperiod) can solve this issue as well:

    https://community.powerbi.com/t5/Desktop/Compare-data-with-previous-period-last-month/td-p/90426

    #11137

    okat
    Participant
    • Started: 8
    • Replies: 11
    • Total: 19

    Hello Stasinek. Thank you very much, I have solved it that way, since it seems to be the most appropriate. Thanks again for the contribution.

    #11138

    okat
    Participant
    • Started: 8
    • Replies: 11
    • Total: 19

    Thanks a lot.

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

You must be logged in to reply to this topic.