Add a new column in a table to change measure value based on the row level category

[RDHR]

Hi,

I am trying to create a table in power bi like the one listed below.  Can anybody advise how to do that? Thanks!!

2024Rate column is a measure calculation.

2025Rate= 2024Rate +/- Increase Rate from raw data for each category.

table visulization:

category	2024Rate	2025Rate
1	2%	3%
2	3%	5%
3	2%	3%
4	5%	6%
5	6%	9%

Raw data

category	Increase rate
1	1%
1	1%
1	1%
1	1%
3	1%
2	2%
4	1%
5	3%

[mickey64 · Accepted solution]

Step 1: I use 2 data tables.

    '2024Rate' table:

    

    'Raw data' table:

    

Step 2: I add a relationship.

    

Step 3: I add '2025Rate' column to '2024Rate' table.

    2025Rate = [2024Rate]+CALCULATE(AVERAGE('Raw data'[Increase rate]),ALLEXCEPT('2024Rate','2024Rate'[category]))

    

[RDHR]

Thank you!!