Exponential formula with DAX

[egrellert]

Hey guys! I need to create a "what-if" dashboard.

my problem is to apply this:
someone will pick the "N" variable with a parameter (1-60)

for example, I choose "36":

VP = VF / [ (1+T)^N ]
VP = 2000 / [ (1+0,05)^0 ]
VP = 2000 / [ (1+0,05)^1 ]
VP = 2000 / [ (1+0,05)^2 ]
(...)
VP = 2000 / [ (1+0,05)^36 ]

how can i do this?? I tried to create a "for loop" but I couldn't create

[v-jianboli-msft · Accepted solution]

Hi @egrellert ,

Based on your description, I have created a simple sample:

Please try:

First create a parameter for N variable:

Then create a measure:

Measure = DIVIDE(MAX('Table'[VF]),(1+MAX('Table'[T]))^MAX('Parameter'[Parameter]))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[egrellert]

Perfect! Thank you!!