Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi to all,
Need to fix something in my formula.
I have created the following formula as common to do a running total.
With Out Column in the Matrix:
any thoughts on why day 21 changes? also, notice that day 19 to day 22 calculation are consistent
Solved! Go to Solution.
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,
Hi @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.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |