Using Running Total to find Associated Week numbers

Question

Hi All,&nbsp;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

amitchandak · Answer

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

tsepo · Answer

amitchandak&nbsp;, Yes precisely.

Forum Discussion

Using Running Total to find Associated Week numbers

2 Replies

Related content

Running Maximum

Running sum

Running Totals

Pipeline not running

Associate Identity to fabric Item