Forum Discussion
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 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 !!
5 Replies
That was very helpful, thank you so much !!
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 I'm trying to create same values in a column in powerBI but have them incremented based on the incremented year
