Forum Discussion
Solved
Cumulative Value fix
Hi Expert, Need you expert advice in fixing my dex query for calculting cumulative value for each year seprately. For first 11 period in 2023 the values are getting calcuated currectly. But from ...
Hi Gaurav_84 ,
You can try to create a measure.
MEASURE = CALCULATE ( SUM ( 'Table'[Amount] ), FILTER ( ALL ( 'Table' ), 'Table'[Fiscal Year] = MAX ( 'Table'[Fiscal Year] ) && 'Table'[Period] <= MAX ( 'Table'[Period] ) ) )If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Gaurav_84 ,
You can try to create a measure.
MEASURE =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER (
ALL ( 'Table' ),
'Table'[Fiscal Year] = MAX ( 'Table'[Fiscal Year] )
&& 'Table'[Period] <= MAX ( 'Table'[Period] )
)
)
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Clara, It work 🙂
Can you please also suggest what modification needs to be done in your formula to calculate previous month cumulative total.