Forum Discussion
Running total by group and by date
Hello, I have the following table and i am trying to create a running total column for the Invoice column for each Document ID by Received date. The date format is: dd/mm/yy From my understanding, ...
HotChilli I have created the following quick measure:
The corresponding auto-generated DAX code:
Invoice running total in Received = CALCULATE( SUM('Invoice Table'[Invoice]), FILTER( ALLSELECTED('Invoice Table'[Received]), ISONORAFTER('Invoice Table'[Received], MAX('Invoice Table'[Received]), DESC) ) )The results in a table is correct:
HotChilli Thanks for your reply! I will investigate the Running Total Quick Measure but it should be limited per Document ID. I have fixed the expected results.
HotChilli I have created the following quick measure:
The corresponding auto-generated DAX code:
Invoice running total in Received =
CALCULATE(
SUM('Invoice Table'[Invoice]),
FILTER(
ALLSELECTED('Invoice Table'[Received]),
ISONORAFTER('Invoice Table'[Received], MAX('Invoice Table'[Received]), DESC)
)
)
The results in a table is correct:
Hi I used this fine on just dates, but as soon as I put the year into a pivot table the calculation begins from fresh each year in the rolling count of the buy quantity. Any ideas how to alter the formula to correct?
ie 27/01/2021 should be 29, 13 from 1st year and 16 from the transaction on the 17/01/2021
