Toggle navigation
Portfolio Slicer
Home
About
News
Documents
Download
Support
Contact
Forum
Discussions
Activity
Home
›
Excel Workbook
Sign In
·
Register
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
Recent Discussions
Activity
Categories
705
All Categories
24
Portfolio Slicer for Power BI
27
Suggestions
28
Migration
113
External Data Files
176
Excel Workbook
135
General
Formula for Annualized RoR
mstraw
September 2021
in
Excel Workbook
I am trying to use the formula for Annualized RoR
I can find "Annlzd RoR:=IF(CONTAINS(Symbol,Symbol[Symbol],"* Cash")
Unfortunately I not understand this .
Can anyone shed some light ?
Comments
VidasMatelis
September 2021
Hi,
In PortfolioSlicer I am using DAX function XIRR to calculate the annualized rate of return. Please read more here:
https://docs.microsoft.com/en-us/dax/xirr-function-dax
Sign In
or
Register
to comment.
Forum Software Powered by Vanilla
Comments
In PortfolioSlicer I am using DAX function XIRR to calculate the annualized rate of return. Please read more here:
https://docs.microsoft.com/en-us/dax/xirr-function-dax