Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!