Forum Discussion
Solved
Cumulative Revenue increase based on a column
Hi guys, I'm struggling with an issue and hopefully someone can help me out. Basically I have a table that has a report date (monthly) a client and I've added a rank based on the report date....
BI-Geniuz here is the measure, tweak it as you see fit.
Data1 = VAR __initialValue = 100 RETURN __initialValue * ( PRODUCTX ( FILTER ( ALL ( 'Table' ), 'Table'[Rank] <= MAX ( 'Table'[Rank] ) ), ( 1 + CALCULATE ( MAX ( 'Table'[Perc Increase] ) / 100 ) ) ) )ouput
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
