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

[10168]

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 the years. I'm trying to replicate below excel in power BI based on just the metric table attached, beginning from 2023. Any help or directions are most appreciated as I cannot have below table in PowerBI as the metrics are subjected to change. Thank you !! 

[tamerj1 · Accepted solution]

@10168 

Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )

Inflation Rate = Data[Growth Rate] * 2

[10168]

That was very helpful, thank you so much !! 

[tamerj1]

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

[10168]

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

[10168]

Year	Projects	Cost	Growth Rate	Inflation Rate
2023	B02 Admin/Visitor Bldg	$348,327	0.03	0.06
2024	B02 Admin/Visitor Bldg	$3,323,044	0.06	0.12
2025	B03 Warehouse	$628,142	0.09	0.18
2026	B03 Warehouse	$2,996,237	0.12	0.24
2027	B03 Warehouse	$3,176,011	0.15	0.3
2027	B04 Shop 2	$949,337	0.15	0.36
2028	B04 Shop 2	$4,528,339	0.18	0.36
2029	B04 Shop 2	$4,800,039	0.21	0.42
2030	B05 Lumber Blast Shed & Paint Shop	$696,193	0.24	0.48
2031	B05 Lumber Blast Shed & Paint Shop	$320,840	0.27	0.54
2032	B05 Lumber Blast Shed & Paint Shop	$3,520,090	0.3	0.6