cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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.

Highlighted
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
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors