Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
awff
Helper III
Helper III

Getting values from a table with original ID and renewal ID in same table

Hi all,

 

I've spent way too long trying to work out how to do this...

 

Basically, I have a query using Salesforce Objects where in the opportunity we link the renewal opportunity (renewalOpportunity__c) to the original opportunity (Id). To get the product items,there is a relationship from the opportunity to the quote, then to the quote line items.

 

 I can get all the products, units and price of the the original opp, but how can I get the ones for the renewal opp for comparison to see the unit and price change between the original and renewal?

 

awff_1-1721697136779.png

 

Ideally, the result would be as below:

Original OppRenewal OppProductOriginal UnitsOriginal UnitsRenewal UnitsRenewal Units
Original 1Renewal 1A2100031100
Original 1Renewal 1B3120031300
Original 1Renewal 1C3150031550
Original 2Renewal 2A1105011100
Original 2Renewal 2B19002900
Original 3 C11500  

 

Hopefully this makes sense as I am going crazy as I feel it can 't be as hard as I am making it !

 

Thank!

4 REPLIES 4
RossEdwards
Solution Sage
Solution Sage

Your modelling is correct.  What happens with you put the columns into a Table visual and mark the fields as "Do Not sumamrize"?

Hi Ross, Thanks for your response! The result remain unchanged.

 

I'm not sure if there is a measure that can be used to get the specifically use the Opportunity[renewalOpportunity__c] id to match with the Quote[OpportunityId], then get the values such as unit price and quantity from the Quote line item table.

 

I was able to get the results with some complex conditons in Python, but seems like i'm going in circles in Power Query and DAX

I've taken your basic design and simplified the columns for an example.  Don't worry if my exact columns aren't right, what matters is which tables i'm pulling stuff from so you can see that this works.  Hopefully we can work backwards and figure out where you have gone wrong.

 

Here is the basic modelling in my example:

RossEdwards_0-1721779724190.png

 

Here is a very basic layout in a table without using any measures:

RossEdwards_1-1721779777498.png

 

Without using any measures, can you get a table that shows anything like this using just columns?  One test can be to start with all of your columns and remove all the measures. See if you get a table that is right.

 

Anonymous
Not applicable

Hi @awff ,

 

Is it possible to share the sample file, or share the data in a table?

 

Best regards,
Community Support Team_ Scott Chang

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.