Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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