Forum Discussion
Solved
DAX equivalent of Excel 'YIELD' function
Hi All,
I am looking for the DAX equivalent of Excel 'YIELD' function to calculate yields on bonds. Can someone let me know how we can Implement the function in DAX?
Thank you
You probably need to recreate the formula that Excel uses for YIELD, these links may help:
https://support.office.com/en-us/article/YIELD-function-F5F5CA43-C4BD-434F-8BD2-ED3C9727A4FE
http://www.tvmcalcs.com/index.php/calculators/apps/excel_bond_yields
1 Reply
- Greg_Deckler
Community Champion
You probably need to recreate the formula that Excel uses for YIELD, these links may help:
https://support.office.com/en-us/article/YIELD-function-F5F5CA43-C4BD-434F-8BD2-ED3C9727A4FE
http://www.tvmcalcs.com/index.php/calculators/apps/excel_bond_yields