Forum Discussion
Solved
Trying to pull column from another table
Hi Everyone, I have two worsksheet in excel i am trying to show table in power bi. I need to bring Total cost from work sheet 2 into Worksheet 1 so that i can Achieve PO Issue * Total cost. I trie...
For Worksheet 2, create a summary table...
Summary Table = SUMMARIZE('Work Sheet 2',ID, "Total Cost",SUM([Total Cost]))Then in Worksheet 1 use a lookup in a calculated column..
TotalCost = LOOKUPVALUE('Work Sheet 1'[ID],'Summary Table'[ID],[Total Cost])
Great, could you mark my answer as solution?
Sure