Forum Discussion

Maeaex1's avatar
Maeaex1
Frequent Visitor
2 years ago

Rebased Performance Chart based on Daily Returns

Hi Community,  I try to calculate a performance chart over time that starts at 100 (start date). I already created a measure that calculated the daily returns. Based on these returns the performan...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Maeaex1 

You can refer to the following solution.

Sample data 

1.I create a measure to display the daily return +1

Daily Return+1 = SUM('Table'[Daily Return])+1

2.Create a response measure

Resonse = PRODUCTX(FILTER(ALLSELECTED('Table'),[Date]<=MAX('Table'[Date])),[Daily Return+1])*100

Output

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.