Rolling 12 months average 02-05-2021 12:17 AM Hello, I know there are a number of questions on Rolling 12 months already, However, i was not able to find one that fits my needs. I need to create a bar chart with months on x-axis and values on y-axis as mentioned below:...
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be used. You may change your...
"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumTopicMessage:message:1963705"},"conversation":{"__ref":"Conversation:conversation:1963705"},"subject":"Re: Rolling MTD Average","moderationData":{"__ref":"ModerationData:moderation_data:1964059"},"...
I realize numerous examples are present of this Rolling 12 Month average are already present on the community but none of them 'intergrate' with a - 355267
The following code provides a result, and I think it's something close to the Weighted Average XIRR by asset (weighted by Period 0 negative cash flow): zzXIRR 1 = CALCULATE( XIRR(GROUPBY(zzNew_Portfolio_Outputs,zzNew_Portfolio_Outputs[Asset ID],zzNew_Portfolio_Outputs[Cash Flow after Debt...
The following code provides a result, and I think it's something close to the Weighted Average XIRR by asset (weighted by Period 0 negative cash flow): zzXIRR 1 = CALCULATE( XIRR(GROUPBY(zzNew_Portfolio_Outputs,zzNew_Portfolio_Outputs[Asset ID],zzNew_Portfolio_Outputs[Cash Flow after Debt...
Microsoft Support Community
Forum Discussion Share Resources
Hey there! Thanks, the code worked great. However, I just realised that I will actually need another filter on the table for company name, as there
The following code provides a result, and I think it's something close to the Weighted Average XIRR by asset (weighted by Period 0 negative cash flow): zzXIRR 1 = CALCULATE( XIRR(GROUPBY(zzNew_Portfolio_Outputs,zzNew_Portfolio_Outputs[Asset ID],zzNew_Portfolio_Outputs[Cash Flow after Debt...