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
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] )
)
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] )
)
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
