Forum Discussion
SUMX with multiple tables
Dear Community, There is a formula I have been looking for and can''t figure it out. I have several tables in my model for Projects, Contracts and percentage progress as planned and real progress. ...
v-sihou-msft
Microsoft Employee
Microsoft Employee
In this scenario, your Amount can map RealProgress properly. However, your Project has 1 to many relationship to plannedProgress, which means your Amount can never get a specific corresponding PlannedProgress. This is the reason why your formula can't work.
Regards,