Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In below examples,i need a column (Sum of QOH) which has Logic = Sum of P_QOH(W1) + Inbound(W1) - Outbound(W1),
but P_QOH column has values only for week 1 and i need to calculate this for lets say "n" no. of weeks.
even the values which we get in column (Sum of QOH) W1 should behave as value for Sum of P_QOH (W2) for the rest of the calculation so the logic becomes Sum of QOH(W2) = Sum of QOH(W1) + Inbound(W2) - Outbound(W1).
my data is in below format,
ItemC | Site | Week | Con | Sum of P_QOH | Sum of Inbound | Sum of Outbound | Sum of QOH(desired) |
100100 | 0 | 1 | 0-1 | 520614 | 0 | 2163 | 518451 |
100100 | 1 | 1 | 1-1 | 101119 | 0 | 1497 | 99622 |
100100 | 2 | 1 | 2-1 | 1562 | 0 | 0 | 1562 |
100100 | 3 | 1 | 3-1 | 18062 | 0 | 666 | 17396 |
100100 | 4 | 1 | 4-1 | 3300 | 0 | 0 | 3300 |
100100 | 5 | 1 | 5-1 | 528 | 0 | 0 | 528 |
100100 | 6 | 1 | 6-1 | 396043 | 0 | 0 | 396043 |
100100 | 0 | 2 | 0-2 | 0 | 58894 | 49597 | 527748 |
100100 | 1 | 2 | 1-2 | 0 | 0 | 6256 | 93366 |
100100 | 2 | 2 | 2-2 | 0 | 0 | 66 | 1496 |
100100 | 3 | 2 | 3-2 | 0 | 8228 | 496 | 25128 |
100100 | 4 | 2 | 4-2 | 0 | 0 | 730 | 2570 |
100100 | 5 | 2 | 5-2 | 0 | 0 | 0 | 528 |
100100 | 6 | 2 | 6-2 | 0 | 50666 | 42049 | 404660 |
Solved! Go to Solution.
Hey,
got the solution and it work fine, refer below logic
Sum of QOH(desired) |
Hi,
I assume you want a measure (and not a calculated column) solution. If that is indeed the case, then share share the download link of the PBI file. Ensure that there is
Hey,
got the solution and it work fine, refer below logic
Sum of QOH(desired) |
Why is the result in Row 3 not picking up the values from rows 1 and 2 ?