EFFECT 05-02-2020 10:18 AM - last edited 05-11-2020 07:36 AM

[Greg_Deckler]

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