cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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 !!

1 ACCEPTED SOLUTION
Super User
``Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )``
``Inflation Rate = Data[Growth Rate] * 2``
5 REPLIES 5
Super User
``Growth Rate = 0.3 * ( Data[Year] - MIN ( Data[Year] ) + 1 )``
``Inflation Rate = Data[Growth Rate] * 2``
Helper I

That was very helpful, thank you so much !!

Super User

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

Helper I

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

Helper I
 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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors