Forum Discussion
Solved
Exponential formula with DAX
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 ] ...
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.
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.
Perfect! Thank you!!
