Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Hi Icey,
Thans!. Its help.
JS
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |