Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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]))
)
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
105 | |
69 | |
48 | |
47 | |
47 |