locked
Same Month Last Year Caculation RRS feed

  • Question

  • Greetings,

    I'm trying to create a measure which gives gives me MTD Sales from the same month last year. However, I don't think my Dates filter is correct.

    Same Month Last Year Sales = CALCULATE([MTD Sales],
    FILTER(ALL(Dates), Dates[Date] > DATEADD(Dates[Date],-1,YEAR) ))

    Here is what I get:  It's wrong. 

    The correct should look like this:

    201601 = 100 (MTD Sales from 201501)

    201602 =  125 (MTD Sales from 201502)

    Any feedback is greatly appreciated.

    Wednesday, May 23, 2018 7:41 PM

Answers

  • Hi Jeannette_81,

    Thanks for your question.

    For this issue, please refer to similar thread that I answered before:
    How to get the prior year MTD value


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Jeannette_81 Thursday, May 24, 2018 5:11 PM
    Thursday, May 24, 2018 2:52 AM

All replies

  • Hi Jeannette_81,

    Thanks for your question.

    For this issue, please refer to similar thread that I answered before:
    How to get the prior year MTD value


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Jeannette_81 Thursday, May 24, 2018 5:11 PM
    Thursday, May 24, 2018 2:52 AM
  • Thanks, Willson!
    Thursday, May 24, 2018 5:11 PM