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 o...
Need Help
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
      1 year 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.