Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Wolly
Helper I
Helper I

Measure - can't add back 1 to productx formula

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!
1 ACCEPTED SOLUTION
Wolly
Helper I
Helper I

Disregard request - it was a data error

View solution in original post

3 REPLIES 3
Wolly
Helper I
Helper I

Disregard request - it was a data error

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you Amit.

 

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.