Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

accumulated column

Hello everyone. I have the following problem making a cumulative sum. First try to make a cumulative measure and everything works well using the following function: cumulative measure - CALCULA...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , The first formula should work. But I do see dates in ascending order in the visual so can not comment.

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    @amitchandak What I need to know is because the function to calculate column-aquerized sum is calculating with defects.

    I have also used the following function:

    SUMX (
    FILTER (
    Hoja1,
    Sheet1[Date] <- EARLIER ( Sheet1[Date] )
    ),
    Sheet1[Amount]
    )
    But it also shows errors, as seen in the image I incorporated. I don't know how to load the sample data I have. Helpyy!
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    @amitchandak Apparently when you change the year, the function stops working properly, is there any solution to that problem? Any variant of the other functions sent, so that it calculates in the same way as the function used for the measurement?

    Best regards.