Running Addition Column

[ziyabikram96]

Hi,

I am trying to calculate a column where it adds the working days in a running form. On 15th March, total working days would be 2, and 3 on 16th March. I require a column, not a measure. I have tried various methods but they return total working days till the maximum date in the table, not till a date in the row.

How can it be solved?

Thanks alot

[ErikHamoen · Accepted solution]

Please check this article:

https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115 

Cumulative working days = 
CALCULATE (
    SUM ( 'Table'[Is WorkingDay] ),
    ALL ( 'Table' ),
    'Table'[Date] <= EARLIER ( 'Table'[Date] )
)