cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ziyabikram96
Resolver I
Resolver I

Running Addition Column

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

ziyabikram96_0-1615560753567.png

 

1 ACCEPTED SOLUTION
ErikHamoen
Resolver I
Resolver I

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] )
)

 

ErikHamoen_0-1615561430463.png

 

View solution in original post

1 REPLY 1
ErikHamoen
Resolver I
Resolver I

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] )
)

 

ErikHamoen_0-1615561430463.png

 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors