Forum Discussion

BI-Geniuz's avatar
BI-Geniuz
Advocate I
5 years ago
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....
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    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.⚡

     

     

     

parry2k's avatar
parry2k
Super User
5 years ago

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.⚡

 

 

 

BI-Geniuz's avatar
BI-Geniuz
Advocate I
5 years ago

Thanks a lot Parry, I never came across the ProductX statement! Great job and keep up the good work, you've saved my weekend!! 😃