EFFECT

In my recent quest to create or catalog as many DAX equivalents for Excel functions, EFFECT was a cinch:

 

EFFECT = 
    POWER(
        (1 + [Nominal_rate Value] / [Npery Value]),
        [Npery Value]
    ) - 1

 

And via Algebra, NOMINAL:

NOMINAL = 
    VAR __Effect =[EFFECT]
    VAR __Npery = [Npery Value]
RETURN
    ( POWER(__Effect+1,1/__Npery) - 1) * __Npery

eyJrIjoiM2EzODBlYmYtZmE1Ni00ZGE1LWFiYTYtOGFlZjczODgzMTJkIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9