Iterative calculation

[anesbbs]

Hi, I want to create a table like this in power bi report visualization.

Column [x] consist of sequence number.

Column [fx] consist of an iterative calculation: 5^[x] * SUM(5^0; 5^1; ... ;5^[k-1]). 

In the sample above, k=4 and this value can change based on other measure calculation.

How to create this with DAX?

[pratyashasamal]

Hi @anesbbs ,
Please refer to this link
https://community.fabric.microsoft.com/t5/Community-Blog/Iteration-in-DAX/ba-p/1223311
Hope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C