Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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!!
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |