Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
If you want cumulative
This need row context to need to be in filter and in max
cumulated hours =
CALCULATE(
[Hours] ,
ALLSELECTED( 'calendar' ), filter('calendar'[week num] <=max('calendar'[week num]))
)
Forgot table in filter
cumulated hours =
CALCULATE(
[Hours] ,
ALLSELECTED( 'calendar' ), filter('calendar','calendar'[week num] <=max('calendar'[week num]))
)
Appreciate your Kudos.
Hi @bbbt123 ,
Your formula seems to be correct, maybe it is a data issue?
Please check if your No.11 week's data is correct. Or is the "Hours" column determined by the calculation formula?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
151 | |
121 | |
73 | |
71 | |
63 |