Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am trying to replicate this code from a java program to DAX:
int a = 0;
int b = 0;
int c = 0;
for(int i =1; i<=5; i++){
b = 3*i;
c = b-a;
int r = b * (c+a)/2;
a += r;
}
I have tried looping through with GENERATESERIES as shown https://community.powerbi.com/t5/Community-Blog/For-and-While-Loops-in-DAX/ba-p/636314 but I can't figure it out
Thanks
Thanks. I would really appreciate the help
@Beniovo I don't believe it is possible due to the recursive aspect of the "a" variable but I'll toy around with it if I can.
User | Count |
---|---|
13 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |