Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
164 | |
132 | |
131 | |
95 | |
86 |