topic Re: Using Running Total to find Associated Week numbers in DAX Commands and Tips

Using Running Total to find Associated Week numbers

Tsepo — Wed, 30 Mar 2022 13:24:11 GMT

Hi All,

I used a Quick measure to find running Sales total for the below table.

I would like to find Weeks when running Sales total was 25%, 50% and 75% of the Total Sales (5 835). I don't wish to manually add a calculated column to the above table.
Is there a solution besides adding a calculated column to my problem?

Thanks

Re: Using Running Total to find Associated Week numbers

amitchandak — Wed, 30 Mar 2022 13:27:10 GMT

Tsepo , Are you looking for somthing like percentile ?

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459

Re: Using Running Total to find Associated Week numbers

Tsepo — Wed, 30 Mar 2022 13:33:04 GMT

amitchandak , Yes precisely.