none
Dax for calculatinf rolling sum

    Question

  • Hi,

    i have a date with datekey,mm/dd/yyyy,fulldate,yyyy-mm(fk) in my date dimension and month dimension with Monthkey,yyyy-mm(pk),MonthNAme,MonthNum,Qtr,Year

    yyyy-mm is varchar

    I want to calculate 3month rolling sum .Pls let me know how to achieve this

    Friday, May 04, 2018 8:36 PM

All replies

  • Hi msdnpublic1234,

    Thanks for your question.

    It is pretty hard to answer this without sample data. To solve your question more efficiently, would you mind typing out 5-10 rows of example data for these table, then showing what results you are expecting based on those sample data? It is much better if you can share the EXCEL work book. Do mask sensitive data before uploading.

    To calculating rolling sum, please refer to below similar thread:

    https://community.powerbi.com/t5/Desktop/Rolling-Sum-Calculation/m-p/130228


    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

    Monday, May 07, 2018 3:11 AM
    Moderator
  • Willson,

    I have attached the sample data,pls help.

    Monday, May 07, 2018 1:21 PM
  • Hi msdnpublic1234,

    Thanks for sharing the sample data.

    what results you are expecting based on those sample data?

    One more thing, from your original question, you have date dimension and month dimension, how did you connect them the your sample data?


    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

    Tuesday, May 08, 2018 1:41 AM
    Moderator
  • Hi msdnpublic1234,

    I am writing to follow up with you on this post. I found you have solved this issue in another post below:

    rolling sum in dax grouped by specific column

    To close this thread, please kindly mark the helpful replies as answers. By doing so, it will benefit all community members who are facing this similar issues. Your contribution is highly appreciated.


    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

    Wednesday, May 16, 2018 5:30 AM
    Moderator