Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Ola
Preciso do acumulado atual somando o valor atual com o acumulado anterior multiplicado por uma taxa de crescimento:
X_Acum = X + (X_Acum ano anterior * (1 + Taxa_Crescimento_Y))
Para ilustrar, a coluna amarela do excel anexada mostra o valor obtido.
Excel aqui
Solved! Go to Solution.
Hi @Vilmar
The difficulty is that when creating a column with DAX, it is not possible to refer to a value in the same output column of previous row like that in Excel. Iteration is complicant in DAX. I will try to find a possible solution but I cannot guarantee it.
Best Regards,
Community Support Team _ Jing
Help please
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |