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.
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

hemantkg

 

Try using TotalMTD

 

MTD = TOTALMTD(SUM(Table1[Sales]),Table1[Date])

hemantkg's avatar
hemantkg
Frequent Visitor
9 years ago

Thanks Victor for quick reply. Tried it, it doesnt even work as expected:

 

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    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

     

     

     

  • hemantkg's avatar
    hemantkg
    Frequent Visitor
    9 years ago

    The TOTALMTD works now, but it is working same as the other calculation, this is the TOTALMTD formula:

     

    MTD using Total MTD = TOTALMTD(Sum(Sheet1[Sales]), 'Date'[Date], ALLEXCEPT(Sheet1, Sheet1[Sales Person], Sheet1[Geography]))

     

     

    But we still have the missing previous total for combination mentioned in OP.