EFFECT DAX Function (Financial)
Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
Syntax
EFFECT ( <Nominal_rate>, <Npery> )
| Parameter | Attributes | Description |
|---|---|---|
| Nominal_rate |
The nominal interest rate. |
|
| Npery |
The number of compounding periods per year. |
Return values
Scalar A single decimal value.
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/effect-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies