Measure - can't add back 1 to productx formula

[Wolly]

I created a measure to link financial returns.

Linked return = productx(PerformanceManager,[return]+1).  For sake of example, one row has a calculation of LR of 106%

When I want to subtract 1 from Linked Return to give me net performance (ie 6%).  Each time I try, it results in the calculation defaults to -1

I even tried simplifying with yet a 2nd measure:

Linked Return Less One = PerformanceManager[Linked return]-1

Result is still -1.  And then i find Linked Return value disappears?!

Help always appreciated!

[Wolly · Accepted solution]

Disregard request - it was a data error

[amitchandak]

@Wolly , Seem like you are looking for a cumulative measure

Return cumm = Cumm Sales = CALCULATE([return]+1,filter(all('Date'),'Date'[date] <=max('Date'[date])))

and then use

Linked return = productx(PerformanceManager,[Return cumm])

You can consider window function for the same

examples

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALLSELECTED('date'[date]),ORDERBY('Date'[date],ASC)))

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

[Wolly]

Thank you Amit.

I'm still not see how I then subtract the number 1 from the Linked Return