Sum of a column with repeating values - DO NOT DISPLAY
In the attached how would I not display the sum value 837418.20 for the rest of the days where there are no actual values yet? Please see THE FORMULA BELOW and you would understand what I am trying to do.
Hi, so as you can see from the above, the 'My measure' formula is doing the job of not repeating the max value till 31st January but adding up incorrectly. It should be cumulative i.e. Jan 4th should start from 41,000, Jan 5th should be newcolumn.disbursed advance amount 168,139.69 + 41,000 = 209,139.69 and so on. The values should be same as the 'Total PP this month' column. Is it something to do with the formula?
Formula used is:
My Measure = VAR SumDAA = CALCULATE ( SUM ( Merge1[NewColumn.Disbursed Advance Amount] ) ) RETURN IF ( SumDAA <> BLANK (), CALCULATE ( SumDAA, FILTER ( ALL ( Merge1 ), Merge1[Days into Quarter] < MAX ( Merge1[Days into Quarter] ) ) ), BLANK () )