Forum Discussion

ewakol's avatar
ewakol
Icon for Helper II rankHelper II
2 years ago

Visual calculation - running sum trouble or pbi bug

Hello,

i create running sum using visual calculaction, and have strange problem. Data are for two companies, for one visual calculaction worsk fine, for second the first value is not correct (mark on red) what have huge negative impact on result. 

Someone have similar issue? Any ideas how fix it? or its some bug in pbi? 

I'd be appreciate for help with that.

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ewakol 

     

    What is your expected outcome?

     

    The RUNNINGSUM() function is used for visual-level operations:

    RUNNINGSUM function (DAX) - DAX | Microsoft Learn

    It seems that September is the starting line, the result should be correct.

     

    If possible, share some data(exclude sensitive data) or create some sample data and provide the expected result with backend logic and special examples? It would be helpful to find out the solution. 

     

    You can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • ewakol's avatar
      ewakol
      Icon for Helper II rankHelper II
      2 years ago

      Hello,

      and thank you for reply thanks that i found what is a problem, so i create visualisations based on DAX calendar which cut data to last 12mc + 12mc

       

      its works very good, because i don't want to show data from other periods, instead of running sum, this one must be calculated from the beginning, do you have any idea how cloud i solve this?

       

      • jeroenterheerdt's avatar
        jeroenterheerdt
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        I am not sure I exactly follow what you want, but it looks to me like you are trying to do a running sum over data that is not on the visual. this will not work. RUNNINGSUM only operates over data that's in the visual. Please share the DAX you are using for RUNNINGSUM as well as the data so we can help.