Forum Discussion

hemantkg's avatar
hemantkg
Frequent Visitor
9 years ago
Solved

Running Total - Incorrect Results

I have searched the forum for possible solution to below scenario, could not find any leads.   Following is the data snapshot: Date Sales Person Geography Sales 1/1/2017 A X 10 1/1/...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hemantkg

     

    The problem is that you want a calculated column and my answer was to a measure =(

     

    I'm sure that other friends in community can help you. I'm sign out until tomorrow.

     

    Good Luck

     

     

     

  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago
    Hi hemantkg,

    It's 320 cause you are using calculated column. Behind the scenes, it iterates row by row and cumulatives sum values, but there are 8 rows in April when it should be 9 rows as another months. My recommendation is using calculated measure.
tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago
Hi hemantkg,

It's 320 cause you are using calculated column. Behind the scenes, it iterates row by row and cumulatives sum values, but there are 8 rows in April when it should be 9 rows as another months. My recommendation is using calculated measure.
  • hemantkg's avatar
    hemantkg
    Frequent Visitor
    9 years ago

    Thanks tringuyenminh92. The following formula gives the correct and expected result for a measure:

     

    TOTALMTD(Sum(Sheet1[Sales]), Sheet1[Date])