Forum Discussion

10168's avatar
10168
Helper I
4 years ago
Solved

How do I create incremental values in a column (Multiply by 2) based on a column condition (Year)

Hello Everyone, I have a tricky situaltion where I need to create incremental values in a column (Multiply 0.03 by 2 starting from year 2023) based on a column condition (Year) and increments through...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    10168 

    Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )
    Inflation Rate = Data[Growth Rate] * 2
tamerj1's avatar
tamerj1
Community Champion
4 years ago

10168 

Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )
Inflation Rate = Data[Growth Rate] * 2
10168's avatar
10168
Helper I
4 years ago

That was very helpful, thank you so much !!