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

Hi 10168 
Would you please copy/paste the sample data?

  • 10168's avatar
    10168
    Helper I
    4 years ago
    YearProjects Cost Growth RateInflation Rate
    2023B02 Admin/Visitor Bldg$348,3270.030.06
    2024B02 Admin/Visitor Bldg$3,323,0440.060.12
    2025B03 Warehouse$628,1420.090.18
    2026B03 Warehouse$2,996,2370.120.24
    2027B03 Warehouse$3,176,0110.150.3
    2027B04 Shop 2$949,3370.150.36
    2028B04 Shop 2$4,528,3390.180.36
    2029B04 Shop 2$4,800,0390.210.42
    2030B05 Lumber Blast Shed & Paint Shop$696,1930.240.48
    2031B05 Lumber Blast Shed & Paint Shop$320,8400.270.54
    2032B05 Lumber Blast Shed & Paint Shop$3,520,0900.30.6
  • 10168's avatar
    10168
    Helper I
    4 years ago

    I'm trying to create same values in a column in powerBI but have them incremented based on the incremented year