cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors