The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
19 | |
13 | |
8 | |
5 |