Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
@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
Can you please share some sample data from all 3 tables or a PBIX file? Thanks!
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |