Forum Discussion
WBS and Weighting
Hi,
I have the typical WBS and weighting for different level in two different table. I have link up Lvl 1 and Lvl 2.
Any solution to calculate the project weight at Level 2 using DAX formula? It will give me an error when mulitpy Lvl1 weight and Lvl 2 weight in DAX.
| Project ID | Lvl 1 ID | Lvl 1 WBS DESC | Lvl 1 Weight |
| 101 | 1.1 | Engineering | 0.2 |
| 101 | 1.2 | Procurement | 0.3 |
| 101 | 1.3 | Construction | 0.5 |
| Lvl 1 ID | Lvl 2 ID | Lvl 2 WBS DESC | Lvl 2 Weight | Project Weighting | |
| 1.1 | 1.1.1 | MDR | 0.4 | 0.08 | |
| 1.1 | 1.1.2 | PDMS | 0.4 | 0.08 | |
| 1.1 | 1.1.3 | Procurement Engineering | 0.2 | 0.04 | |
| 1.2 | 1.2.1 | Equipment | 0.6 | 0.18 | |
| 1.2 | 1.2.2 | Bulk Material | 0.4 | 0.12 | |
| 1.3 | 1.3.1 | Topside Module | 0.35 | 0.175 | |
| 1.3 | 1.3.2 | Hull Conversion | 0.4 | 0.2 | |
| 1.3 | 1.3.3 | Integration | 0.25 | 0.125 |
New in DAX and Power Pivot
JS
Hi Anonymous ,
If I understand you correctly, the column "Project Weighting" you provided is what you want to calculate using DAX.
If so, you can create a column like so:
Column = LV2[Lvl 2 Weight] * RELATED ( LV1[Lvl 1 Weight] )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
If I understand you correctly, the column "Project Weighting" you provided is what you want to calculate using DAX.
If so, you can create a column like so:
Column = LV2[Lvl 2 Weight] * RELATED ( LV1[Lvl 1 Weight] )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.