Forum Discussion

Rahul66303's avatar
Rahul66303
Frequent Visitor
8 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Rahul66303,

     

    Please mark the solution as accepted if it worked for you.

     

    Thank you :)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Rahul66303,

 

Please mark the solution as accepted if it worked for you.

 

Thank you :)