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
667
All Categories
23
Portfolio Slicer for Power BI
25
Suggestions
23
Migration
103
External Data Files
168
Excel Workbook
123
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