Forum Discussion
Related tables and forcasting
Hello all, I have 2 tables which are related in a Many to 1 by Contract name. Sales (Many) = A list of sales to multiple customers with these important columns Sales number Contract ...
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Column = RELATED(Table2[Days until contract ends])Column 2 = 'Table'[Price]*'Table'[Column]
2. Create calculated table.
Sales =
SUMMARIZE('Table','Table'[Contract Name],'Table'[Product],"sales",SUM('Table'[Column 2]))3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.