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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kasiaw29
Resolver II
Resolver II

Create summary table from 2 other tables with measures

Hi community, 

 

I need help. I have 3 tables.

 

Table 1 Product table with ID and description

Table 2 Products with their cost from the latest revision 

Table 3 Products with their cost for revision prior to the latest. 

 

Table 2 and 3 are joined with a 1-1 relationship to table 1 on product id. 

What I'm trying to get to is to get a list of products with current cost and cost before revision was made to then calculate cost difference. Looking like this, dummy data sample: 

Product IDDescriptionLatest Revision Cost Prior to Revision Cost Cost Difference 
1Apple £10£5£5

Is this at all possible? 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@kasiaw29 , You should join 1 with 2 and 3 .

I do think you should join 2, 3.

 

The using product details from 1 and min /max cost from 2 and 3, you can put things togther

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @kasiaw29 ,

 

Any sample data for test?

 

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

 

Best Regards,

Icey

amitchandak
Super User
Super User

@kasiaw29 , You should join 1 with 2 and 3 .

I do think you should join 2, 3.

 

The using product details from 1 and min /max cost from 2 and 3, you can put things togther

PaulDBrown
Community Champion
Community Champion

Can you please share some sample data from all 3 tables or a PBIX file? Thanks!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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