How can I assign measures to a specific value in a row

[650AA]

I have the below table and wish to create a new column so that I can assign measures to each row, I have created measures for each row however how would I assigned or link them to the table.  I have no dates in my other table so have created measures summing the colunms as they do not have dates assigned

Thansk again 

[lbendlin · Accepted solution]

You cannot/should not create calculated columns or calculated tables from measures.  only the other way round makes sense.

What are you trying to achieve?

[lbendlin · Accepted solution]

You cannot/should not create calculated columns or calculated tables from measures.  only the other way round makes sense.

What are you trying to achieve?

[650AA]

Hi apologises for the ambiguous explaination, I have a seperate finance table which has the headings as shown below,

I have created a seperate reference table which runs in 5 year fiscal blocks (See table above - which are the same as the control period as shown in the table above. )
( baseline_previous_control_period_y1
baseline_previous_control_period_y2
baseline_previous_control_period_y3
baseline_previous_control_period_y4
baseline_previous_control_period_y5
forecast_previous_control_period_y1
forecast_previous_control_period_y2
forecast_previous_control_period_y3
forecast_previous_control_period_y4
forecast_previous_control_period_y5
remit_previous_control_period_y1
remit_previous_control_period_y2
remit_previous_control_period_y3
remit_previous_control_period_y4
remit_previous_control_period_y5
baseline_current_control_period_y1
baseline_current_control_period_y2
baseline_current_control_period_y3
baseline_current_control_period_y4
baseline_current_control_period_y5
forecast_current_control_period_y1
forecast_current_control_period_y2
forecast_current_control_period_y3
forecast_current_control_period_y4
forecast_current_control_period_y5
remit_current_control_period_y1
remit_current_control_period_y2
remit_current_control_period_y3
remit_current_control_period_y4
remit_current_control_period_y5
baseline_future_control_period_y1
baseline_future_control_period_y2
baseline_future_control_period_y3
baseline_future_control_period_y4
baseline_future_control_period_y5
forecast_future_control_period_y1
forecast_future_control_period_y2
forecast_future_control_period_y3
forecast_future_control_period_y4
forecast_future_control_period_y5
remit_future_control_period_y1
remit_future_control_period_y2
remit_future_control_period_y3
remit_future_control_period_y4
remit_future_control_period_y5
forecast_beyong_future_control_period
remit_beyond_future_control_period)

The issue is I do not have a date Column in the finance table and need to assign each column a date. I created the above table as a reference table, however I am uanble to create a relationship between the two tables.
As the finance table has column heading rather then rows, I am unsure of how I would make this work. I have tried a bridging table, also tried to transpose the finance table.

For example I need to sum colunm baseline_previous_control_period_y1 in the finance table and then assign the column a date( fiscal year 2014). I need to repeat this for all 47 columns and assign a date to the column as per the ref table above.
Do I need to create seperate tables for each coulmn so that I can create a sepereate date coulmn ?
Any help is much apprecaited 

[lbendlin · Accepted solution]

Unpivot that table and eliminate duplicates.