›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Cumulative Rate of Return

ivanmivanm
in General
I would like to set up a chart that shows the cumulative return % throughout the year. I tried modifying the existing chart on the "Yearly" sheet but I think I will need to create a new measure as the profit % one only calculates the return for that specific period (month, year, etc.).

Could someone help me with this?

Thanks,

Ivan

Comments

  • VidasMatelisVidasMatelis
    You would need to first create new measure, something like this:
    Profit % YTD:=CALCULATE([Profit %], DATESYTD ( Dates[Date] ))

    Then you would use that measure in your chart.
    Note - this would be an expensive calculation to calculate Profit % for every day of the year!
  • ivanmivanm
    Thanks so much for your help Vidas. This worked!
Sign In or Register to comment.