Forum Discussion

mareidraper's avatar
mareidraper
Frequent Visitor
8 years ago

Need Help - Cumulative Sum

I am pulling in Opportunity Products from Salesforce Object and trying to determin Year over Year New Business Portion.   Some Opportunities have 5 years of products while others only have 1 year. ...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi mareidraper,

 

I tested the above two measures on my side, both of them returned expected values.

 

The second formula is not pulling the plugged valued into the subtotals/totals.

 

What is the result you have got?

 

Please share some sample data of 'Opportunity Product' and describe your desired output and currently incorrect result with screenshots. If possible, you could directly share the .pbix file.

 

Regards,

Yuliana Gu