Forum Discussion
Running/Cumulative total by multiple group
Hi to all, Need to fix something in my formula. I have created the following formula as common to do a running total. Cumulative % = CALCULATE( DIVIDE([Cumulative Amount Unpaid]...
Hi Anonymous
Glad to hear the reply is helpful, please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.
Regards,
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
Please try below measure.If it is not your case,please share the .pbix file for us to check.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.
Cumulative % =
CALCULATE (
DIVIDE ( [Cumulative Amount Unpaid], [Cumulative Billings] ),
FILTER (
ALLSELECTED ( 'Charge Regsiter Table'[Date From Period] ),
'Charge Regsiter Table'[Date From Period]
<= MAX ( 'Charge Regsiter Table'[Date From Period] )
)
)
Thanks,
that fixed it.
- v-cherch-msft
Hi Anonymous
Glad to hear the reply is helpful, please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.
Regards,