Spreadsheet: 836165d1689148136-power-query-conditional-column-calculate-the-multiplier-at-project-level-power-query-condiitonal-column-aligw
Sheet: Sheet1

Month | Project | Sub-Project | Revenue | Cost | Multiplier | Expected Result |  |  | Month | Project | Sub-Project | Revenue | Cost | Multiplier | ByProject.Multiplier
202301 | 70049143 | 70049143-102 | 2912 | 516 |  |  |  |  | 202301 | 70049143 | 70049143-102 | 2912 | 516 | 5.643410852713179 | 4.4
202301 | 70049143 | 70049143-103 | 1355 | 516 |  |  |  |  | 202301 | 70049143 | 70049143-103 | 1355 | 516 | 2.625968992248062 | 4.4
202301 | 70049143 | 70049143-108 | 4209 | 703 |  |  |  |  | 202301 | 70049143 | 70049143-108 | 4209 | 703 | 5.987197724039829 | 4.4
202301 | 70049143 | 70049143-109 | 2780 | 798 |  |  |  |  | 202301 | 70049143 | 70049143-109 | 2780 | 798 | 3.483709273182957 | 4.4
202301 | 70049164 | 70049164-203 | 2699 | 774 |  |  |  |  | 202301 | 70049164 | 70049164-203 | 2699 | 774 | 3.487080103359173 | 2.9
202301 | 70049164 | 70049164-204 | 2376 | 852 |  |  |  |  | 202301 | 70049164 | 70049164-204 | 2376 | 852 | 2.788732394366197 | 2.9
202301 | 70049164 | 70049164-206 | 2851 | 553 |  |  |  |  | 202301 | 70049164 | 70049164-206 | 2851 | 553 | 5.155515370705244 | 2.9
202301 | 70049164 | 70049164-207 | 1093 | 921 |  |  |  |  | 202301 | 70049164 | 70049164-207 | 1093 | 921 | 1.186753528773073 | 2.9
202302 | 70049164 | 70049164-203 | 1008 | 860 |  |  |  |  | 202302 | 70049164 | 70049164-203 | 1008 | 860 | 1.172093023255814 | 3.2
202302 | 70049164 | 70049164-204 | 4345 | 530 |  |  |  |  | 202302 | 70049164 | 70049164-204 | 4345 | 530 | 8.19811320754717 | 3.2
202302 | 70049164 | 70049164-206 | 1032 | 993 |  |  |  |  | 202302 | 70049164 | 70049164-206 | 1032 | 993 | 1.039274924471299 | 3.2
202302 | 70049164 | 70049164-207 | 1358 | 682 |  |  |  |  | 202302 | 70049164 | 70049164-207 | 1358 | 682 | 1.991202346041056 | 3.2
202302 | 70049164 | 70049164-209 | 4639 | 752 |  |  |  |  | 202302 | 70049164 | 70049164-209 | 4639 | 752 | 6.168882978723405 | 3.2
202302 | 70049143 | 70049143-102 | 3854 | 627 |  |  |  |  | 202302 | 70049143 | 70049143-102 | 3854 | 627 | 6.146730462519936 | 5.2
202302 | 70049143 | 70049143-103 | 3718 | 653 |  |  |  |  | 202302 | 70049143 | 70049143-103 | 3718 | 653 | 5.693721286370597 | 5.2
202302 | 70049143 | 70049143-108 | 4050 | 957 |  |  |  |  | 202302 | 70049143 | 70049143-108 | 4050 | 957 | 4.231974921630094 | 5.2
202303 | 70049143 | 70049143-102 | 2732 | 812 |  |  |  |  | 202303 | 70049143 | 70049143-102 | 2732 | 812 | 3.364532019704434 | 3.4
202303 | 70049143 | 70049143-103 | 3599 | 834 |  |  |  |  | 202303 | 70049143 | 70049143-103 | 3599 | 834 | 4.315347721822542 | 3.4
202303 | 70049143 | 70049143-108 | 1787 | 895 |  |  |  |  | 202303 | 70049143 | 70049143-108 | 1787 | 895 | 1.996648044692737 | 3.4
202303 | 70049143 | 70049143-109 | 3551 | 916 |  |  |  |  | 202303 | 70049143 | 70049143-109 | 3551 | 916 | 3.876637554585153 | 3.4
202303 | 70049164 | 70049164-203 | 3789 | 663 |  |  |  |  | 202303 | 70049164 | 70049164-203 | 3789 | 663 | 5.714932126696833 | 4.6
202303 | 70049164 | 70049164-204 | 3796 | 884 |  |  |  |  | 202303 | 70049164 | 70049164-204 | 3796 | 884 | 4.294117647058823 | 4.6
202303 | 70049164 | 70049164-206 | 4920 | 847 |  |  |  |  | 202303 | 70049164 | 70049164-206 | 4920 | 847 | 5.808736717827627 | 4.6
202303 | 70049164 | 70049164-207 | 2795 | 961 |  |  |  |  | 202303 | 70049164 | 70049164-207 | 2795 | 961 | 2.908428720083247 | 4.6
202304 | 70049143 | 70049143-102 | 3154 | 663 |  |  |  |  | 202304 | 70049143 | 70049143-102 | 3154 | 663 | 4.757164404223228 | 3.8
202304 | 70049143 | 70049143-103 | 1290 | 730 |  |  |  |  | 202304 | 70049143 | 70049143-103 | 1290 | 730 | 1.767123287671233 | 3.8
202304 | 70049143 | 70049143-108 | 3753 | 828 |  |  |  |  | 202304 | 70049143 | 70049143-108 | 3753 | 828 | 4.532608695652174 | 3.8
202304 | 70049143 | 70049143-110 | 3616 | 589 |  |  |  |  | 202304 | 70049143 | 70049143-110 | 3616 | 589 | 6.139219015280136 | 3.8
202304 | 70049143 | 70049143-113 | 2854 | 810 |  |  |  |  | 202304 | 70049143 | 70049143-113 | 2854 | 810 | 3.523456790123457 | 3.8
202304 | 70049143 | 70049143-118 | 1464 | 909 |  |  |  |  | 202304 | 70049143 | 70049143-118 | 1464 | 909 | 1.610561056105611 | 3.8
202304 | 70049143 | 70049143-119 | 3842 | 704 |  |  |  |  | 202304 | 70049143 | 70049143-119 | 3842 | 704 | 5.457386363636363 | 3.8
202304 | 70049164 | 70049164-203 | 3608 | 723 |  |  |  |  | 202304 | 70049164 | 70049164-203 | 3608 | 723 | 4.990318118948824 | 4.1
202304 | 70049164 | 70049164-204 | 2545 | 814 |  |  |  |  | 202304 | 70049164 | 70049164-204 | 2545 | 814 | 3.126535626535627 | 4.1
202304 | 70049164 | 70049164-206 | 4102 | 792 |  |  |  |  | 202304 | 70049164 | 70049164-206 | 4102 | 792 | 5.179292929292929 | 4.1
202304 | 70049164 | 70049164-207 | 2286 | 700 |  |  |  |  | 202304 | 70049164 | 70049164-207 | 2286 | 700 | 3.265714285714286 | 4.1