Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
The challenge here consists of finding the difference between the measures below:
Overview Table
Product | Cost | Plant |
Item1 | 1.00 | Plant A |
Item1 | 2.00 | Plant B |
Item2 | 2.50 | Plant A |
Item2 | 2.30 | Plant B |
Cost Table
Product | Cost |
Item1 | 1.10 |
Item2 | 1.90 |
Item3 | 2.30 |
Hi, @Asantos2020
And you want have the difference between costs for a product, what about the Plant A or B.
Could provide the pbix if possible, so I can create something similar to yours and help your out.
Best,
Paul
Hello @V-pazhen-msft !
I would then need to find the differences between:
Cost ERP = SUM(Cost Table[Cost])
and
@Asantos2020
I find no problem with the difference with the sample I created based on your original post.
Please create a sample pbix that similar to your dataset, including the related columns and relationship between tables,
Paul