Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Need to have a DAX formula to create cumulative of percentage, I need the value like highlighted, its doing cumulative of column C as percentage. Please help
Solved! Go to Solution.
Hi @Anonymous ,
The main idea is to first create column B, get the value of the previous row, and then use divide to calculate the result of divide (11.29-11.23, 11.23,0). Then find column C according to the calculation in column B. You can refer to the links to similar questions below, the ideas are basically the same.
link:Solved: get value from Previous row - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information. Let me know the result immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, I have the same need but the percentage of the total is a calculated measure
Hi @Anonymous ,
The main idea is to first create column B, get the value of the previous row, and then use divide to calculate the result of divide (11.29-11.23, 11.23,0). Then find column C according to the calculation in column B. You can refer to the links to similar questions below, the ideas are basically the same.
link:Solved: get value from Previous row - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information. Let me know the result immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you for the suggestion, i am not getting any error but the output I need in column D is not coming.
Please take some example and show me how to get this..
@Anonymous , if C is a column
calculate(sum(Table[C]), filter(allselected(Table),Table[datetime_date] <=max(Table[datetime_date])))
or C is measure
calculate(sumX(values(Table[datetime_date]) ,[C]), filter(allselected(Table),Table[datetime_date] <=max(Table[datetime_date])))
Thank you very much for the information! I was looking at how to make the cumulative % from a measure.
I work perfectly😁
Thanks @amitchandak for your response, I forgot to mentioned that Column C is also a calculated value from column B doing e.g divide(11.29-11.23, 11.23,0) = 0.47% ans so on (this is not actual but this is how its has been derived.)
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |