cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rahul66303 Frequent Visitor
Frequent Visitor

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  

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: How to join to Calculated table.

Hi @Rahul66303,

 

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

 

Thank you 🙂

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Re: How to join to Calculated table.

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 Frequent Visitor
Frequent Visitor

Re: How to join to Calculated table.

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
Not applicable

Re: How to join to Calculated table.

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
Not applicable

Re: How to join to Calculated table.

Hi @Rahul66303,

 

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

 

Thank you 🙂

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 294 members 2,989 guests
Please welcome our newest community members: