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
ServiceOfferingServiceLineCapabilityBusinessCapabilitiesCoverageValue
ServiceOffering1ServiceLine1Capability1Tag13
ServiceOffering1ServiceLine2Capability1Tag12
ServiceOffering1ServiceLine3Capability1Tag12
ServiceOffering1ServiceLine2Capability2Tag11
ServiceOffering1ServiceLine3Capability2Tag11
ServiceOffering1ServiceLine2Capability3Tag11
ServiceOffering1ServiceLine3Capability3Tag11
ServiceOffering2ServiceLine4Capability4Tag11

 

Another Calculated Table :

 

BaselineTable
ServiceOfferingServiceLineCapabilityBusinessCapabilitiesBaselineValue
ServiceOffering1ServiceLine1Capability1Tag15
ServiceOffering1ServiceLine2Capability1Tag13
ServiceOffering1ServiceLine2Capability1Tag23
ServiceOffering1ServiceLine2Capability1Tag38
ServiceOffering1ServiceLine2Capability1Tag42
ServiceOffering1ServiceLine3Capability1Tag13
ServiceOffering1ServiceLine3Capability1Tag23
ServiceOffering1ServiceLine3Capability1Tag38

 

What i need to join above two tables and result table as calculated table :

CoverageVsBaseLineTable
 ServiceOfferingServiceLineCapabilityBusinessCapabilitiesCoverageValueBaselineValue  
 ServiceOffering1ServiceLine1Capability1Tag135  
 ServiceOffering1ServiceLine2Capability1Tag123  
 ServiceOffering1ServiceLine3Capability1Tag123  
 ServiceOffering1ServiceLine2Capability2Tag118  

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Rahul66303,

     

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

     

    Thank you :)

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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?

    • Rahul66303's avatar
      Rahul66303
      Frequent Visitor
      8 years ago

      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 ?

      • 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.