Forum Discussion
Solved
Problem with accumulated calculation
Hi, I'm having trouble with a cumulative calculation.
The accumulated is done well except in the data that are repeated and in these cases the accumulated does not vary
The code is:
Q pickeo % acumulado = CALCULATE (
SUM('GEN - Q Pickeo por Ubic M-1'[Q pickeo %]),
FILTER: 'GEN - Q Pickeo by Ubiquitous M-1',
'GEN - Q Pickeo por Ubic M-1'[Q pickeo %] >= EARLIER('GEN - Q Pickeo por Ubic M-1'[Q pickeo %])))
This is the table and here below detail the problem best
When the value "100" is repeated, the accumulated one stops adding
Syndicate_Admin , add an index column in power query and use it to calculate cumulative - https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Q pickeo % acumulado = CALCULATE (SUM('GEN - Q Pickeo por Ubic M-1'[Q pickeo %]),FILTER: 'GEN - Q Pickeo by Ubiquitous M-1','GEN - Q Pickeo por Ubic M-1'[Index] >= EARLIER('GEN - Q Pickeo por Ubic M-1'[Index])))
1 Reply
Syndicate_Admin , add an index column in power query and use it to calculate cumulative - https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Q pickeo % acumulado = CALCULATE (SUM('GEN - Q Pickeo por Ubic M-1'[Q pickeo %]),FILTER: 'GEN - Q Pickeo by Ubiquitous M-1','GEN - Q Pickeo por Ubic M-1'[Index] >= EARLIER('GEN - Q Pickeo por Ubic M-1'[Index])))