Forum Discussion
Helper IAvoid Recurring Value in Table
Helper IHi danextian , thanks for responding this post.
So, if you've seen my PBIX file, SourcePlace is places which have the excess items. The amount of these excess items will be allocated to several places who need the items. For example, in the Deficit table, both B and C need "2G", which are "4" and "1"
After that, I want to explore another places that have an excess amount of this "2G". In this sample, only 1 place that have an excess, which is A. But in the reality, we have plenty source places that have an excess amount of this "2G" that need to be allocated to the shortage places.
Do have any ideas?
Helper IIt's similar with supply and demand model, where the "source" warehouse that have an excess amount will supply its units to the "target" warehouse, which is shortage. The idea is to express it using the above table and still thinking about the proper data model and DAX.
- danextian
Super User
Does this mean that regardless of the destination place if a source place has some excess of a material, it can suppy the deficit? You might be able to achieve your desired result by combining all Excess tables into one using Append and doinng a merge between Material (Excess) and Material (Deficit). Doing that will help you achieve the table below:
Now, the question is if the sum of deficit for each material is more than the sum of Excess, which place and material takes priority? And if there are more than two places with excess of the same material, which one should share supply to the deficit first?