How do I Apply an Equation/ Measure Across an Entire Table

[Anonymous]

I am working on a historical data report that revolves around 600 cost codes and applying time and location factors to adjust the costs to current market values (95% of the codes have values so I cannot shrink the tables).  I have imported all of the data into 2 tables that are around 300 columns each, is there an easy way to apply the below equation to all of these columns without individually typing in the same equation 600 times?

194-00032 = IFERROR((('DB_Unit Cost_Time_General Conditions'[Current Year Cost Index]/'DB_Unit Cost_Time_General Conditions'[Time Index])*LOOKUPVALUE(DB_General_Conditions[194-00032],DB_General_Conditions[Project Number],'DB_Unit Cost_Time_General Conditions'[Project Number]))/LOOKUPVALUE(DB_General_Info[Building SF],DB_General_Info[Project Number],'DB_Unit Cost_Time_General Conditions'[Project Number]),0)

[amitchandak · Accepted solution]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Anonymous]

Thanks for the sugestion, I ended up changing how my data was formated and imported into PowerBI so I was able fix the issue.