NOMINAL

NOMINAL is a DAX function that returns the nominal annual interest rate from an effective rate and number of compounding periods per year.

Syntax

NOMINAL(
   Effect_rate,
   Npery
)

Argument	Properties	Description
Effect_rate		The effective interest rate.
Npery		The number of compounding periods per year.

Return Values

The nominal annual interest rate.

Remarks

• The relationship between NOMINAL and EFFECT is shown in the following equation:

  $$\text{EFFECT}=(1+\frac{\text{nominal\_rate}}{\text{npery}}{)}^{\text{npery}}-1$$

• npery is rounded to the nearest integer.

• An error is returned if:

  • effect_rate ≤ 0.
  • npery < 1.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Data	Description
5.3543%	Effective interest rate
4	Number of compounding periods per year

The following DAX query:

EVALUATE
{
  NOMINAL(0.053543, 4)
}

Returns the nominal interest rate, using the terms specified above.

[Value]
0.052500319868356

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/nominal-function-dax