Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all.
I need to create a calculated column using a recursive approach. This is my current code (which of course doesn't work):
@mohammadjavaher , power query you have some option : https://radacad.com/fibonacci-sequence-understanding-the-power-query-recursive-function
refer some DAX solution
https://forum.enterprisedna.co/t/dax-challenge-recursive/9091
Thanks @amitchandak for your response. Bad news is that my table is a cross join between two other tables one of which is totally created by DAX (GENERATESERIES) and the other is a calculated table based on another table. I cannot take this joint table to Power Query, AFAIK. So I need a pure-DAX way to accomplish this.
Regards,
Mohammad
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |