Forum Discussion
What Function should I use for Row Sum?
Question 1) If Part is "A" then sum <Part "B" WH A Qty> & <Part "C" WH A Qty> else <WH A Qty>. What function should I apply in Power BI? Part WH A Qty A 13 B 24 C 56 ...
Let me re-phase my case again. Table below shows Part & Sales Qty
I would like to add custom column to calculate result as per Expected Sales Qty Column.
Condition:
Part B always = Part B Sales Qty + Part D Sales Qty
Part D always = 0
Other Parts = Same Sales Qty
| Part | Sales Qty | Expected Sales Qty |
| A | 12 | 12 |
| B | 45 | 69 |
| C | 67 | 67 |
| D | 24 | 0 |
| E | 52 | 52 |
| F | 45 | 45 |
Reference to a new table, filter it down to D. Add a dummy column "B". Merge it back in matching part column to dummy column. Then everything is on the right rows for you to do a simple custom column if part = D then 0 else expected sales qty + D.sales.