Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
kt_3912
Frequent Visitor

DAX equivalent of Excel 'YIELD' function

‎12-15-2017 05:59 AM

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

Message 1 of 2
1,024 Views
0
1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

‎12-15-2017 08:09 AM

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

 

https://answers.microsoft.com/en-us/office/forum/office_2003-excel/how-excel-calculate-yield-functio...

 

http://www.tvmcalcs.com/index.php/calculators/apps/excel_bond_yields



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Message 2 of 2
1,118 Views
1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

‎12-15-2017 08:09 AM

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

 

https://answers.microsoft.com/en-us/office/forum/office_2003-excel/how-excel-calculate-yield-functio...

 

http://www.tvmcalcs.com/index.php/calculators/apps/excel_bond_yields



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 2
1,119 Views

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All
Top Kudoed Authors
View All