https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/EFFECT/m-p/1062744#M470 <P><A title="" href="https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991" target="_self">In my recent quest to create or catalog as many DAX equivalents for Excel functions</A><SPAN>, EFFECT was a cinch:</SPAN></P> <P>&nbsp;</P> <LI-CODE lang="markup">EFFECT = POWER( (1 + [Nominal_rate Value] / [Npery Value]), [Npery Value] ) - 1</LI-CODE> <P>&nbsp;</P> <P>And via Algebra, NOMINAL:</P> <LI-CODE lang="markup">NOMINAL = VAR __Effect =[EFFECT] VAR __Npery = [Npery Value] RETURN ( POWER(__Effect+1,1/__Npery) - 1) * __Npery</LI-CODE> <P><SPAN class="reportid hidden">eyJrIjoiM2EzODBlYmYtZmE1Ni00ZGE1LWFiYTYtOGFlZjczODgzMTJkIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Mon, 11 May 2020 14:36:11 GMT Greg_Deckler 2020-05-11T14:36:11Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/EFFECT/m-p/1062744#M470 <P><A title="" href="https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991" target="_self">In my recent quest to create or catalog as many DAX equivalents for Excel functions</A><SPAN>, EFFECT was a cinch:</SPAN></P> <P>&nbsp;</P> <LI-CODE lang="markup">EFFECT = POWER( (1 + [Nominal_rate Value] / [Npery Value]), [Npery Value] ) - 1</LI-CODE> <P>&nbsp;</P> <P>And via Algebra, NOMINAL:</P> <LI-CODE lang="markup">NOMINAL = VAR __Effect =[EFFECT] VAR __Npery = [Npery Value] RETURN ( POWER(__Effect+1,1/__Npery) - 1) * __Npery</LI-CODE> <P><SPAN class="reportid hidden">eyJrIjoiM2EzODBlYmYtZmE1Ni00ZGE1LWFiYTYtOGFlZjczODgzMTJkIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Mon, 11 May 2020 14:36:11 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/EFFECT/m-p/1062744#M470 Greg_Deckler 2020-05-11T14:36:11Z