Forum Discussion
Solved
How to join to Calculated table.
Hi, Need help on below scenario : I have two calculated tables : CoverageTable ServiceOffering ServiceLine Capability BusinessCapabilities CoverageValue ServiceOffering1 Ser...
Hi Rahul66303,
The first table is missing only the Baseline value. You could create a column and using Lookup get the Baseline value. Do you have a primary key for the 2 tables?
Hi Anonymous
These two tables are calculated tables from different tables and calculations, i do n't have primary key on these calculated tables ?can i create primary key on calculated tables ?
Hi Rahul66303,
You can create one. Create a column key in both the tables
Key = ServiceOffering & ServiceLine & Capability & BusinessCapabilities
Now create a column Baseline in the first table
Baseline = Lookup(Table2[Baseline], Table2[Key], Table1[Key])
Let me know if this does not work.