Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.