What are DURATION MDURATION and PDURATION in power bi DAX
This recipe explains what are DURATION MDURATION and PDURATION in power bi DAX
Recipe Objective - What are DURATION, MDURATION, and DURATION in Power BI DAX?
DURATION - Returns the Macauley duration for an assumed par value of $100.
MDURATION - Returns the modified Macauley duration for a security with an assumed par value of $100.
PDURATION - Returns the number of periods required by an investment to reach a specified value.
Syntax of DURATION -
DURATION(Settlement, Maturity, Coupon, Yld, Frequency, [Basis])
Parameters -
Settlement - The security's settlement date.
Maturity - The security's maturity date.
Coupon - The security's annual coupon rate.
Yld - The security's annual yield.
Frequency - The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
Returns the Macauley duration.
Syntax of MDURATION -
MDURATION(Settlement, Maturity, Coupon, Yld, Frequency, [Basis])
Parameters -
Settlement - The security's settlement date.
Maturity - The security's maturity date.
Coupon - The security's annual coupon rate.
Yld - The security's annual yield.
Frequency - The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
Returns the modified Macauley duration.
Syntax of PDURATION -
PDURATION(Rate, Pv, Fv)
Parameters -
Rate - The interest rate per period.
Pv - The present value of the investment.
Fv - The desired future value of the investment.
Returns the number of periods required by an investment to reach a specified value.
In this way, we can use DURATION, MDURATION, and PDURATION functions in Power BI DAX.
Download Materials
What Users are saying..
Gautam Vermani
Having worked in the field of Data Science, I wanted to explore how I can implement projects in other domains, So I thought of connecting with ProjectPro. A project that helped me absorb this topic... Read More