Forum Discussion

Vilmar's avatar
Vilmar
Icon for Resolver I rankResolver I
4 years ago
Solved

Acumulado Com Percentual

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 

Need Help

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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