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
Solved! Go to 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] )
)
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] )
)
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
346 | |
100 | |
62 | |
51 | |
47 |
User | Count |
---|---|
333 | |
124 | |
86 | |
66 | |
65 |