Create summary table from 2 other tables with measures

[kasiaw29]

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 ID	Description	Latest Revision Cost	Prior to Revision Cost	Cost Difference
1	Apple	£10	£5	£5

Is this at all possible? 

[Icey]

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 · Accepted solution]

@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]

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