Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 !!
Solved! Go to Solution.
Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )
Inflation Rate = Data[Growth Rate] * 2
Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )
Inflation Rate = Data[Growth Rate] * 2
That was very helpful, thank you so much !!
I'm trying to create same values in a column in powerBI but have them incremented based on the incremented year
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 |
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |