Forum Discussion
Solved
% by Week and Group
Hi can anyone help me on my calculated column. On my table i want to get the % by Group each week.
Sample the group QQQQQ123 on Week 21 it has a count of 4 and RCVD STOCK of 3
4-3/4 = 25.00%
OUTPUT
| Group | JobNo. | COUNT | RCVD STOCK | Year Week Column | % WEEKLY |
| QQQQQ123 | rujrytj | 1 | 0 | 2026 -Week 21 | 25.00% |
| QQQQQ123 | ghd | 1 | 1 | 2026 -Week 21 | 25.00% |
| QQQQQ123 | jdytj | 1 | 1 | 2026 -Week 21 | 25.00% |
| QQQQQ123 | tyj | 1 | 1 | 2026 -Week 21 | 25.00% |
| GFRT678 | jdtyj | 1 | 1 | 2026 -Week 21 | 50.00% |
| GFRT678 | tyj | 1 | 0 | 2026 -Week 21 | 50.00% |
| GFRT678 | dyjdy | 1 | 1 | 2026 -Week 21 | 50.00% |
| GFRT678 | dtyj | 1 | 0 | 2026 -Week 21 | 50.00% |
| TYUI0987 | jdtjy | 1 | 0 | 2026 -Week 21 | 80.00% |
| TYUI0987 | djd | 1 | 0 | 2026 -Week 21 | 80.00% |
| TYUI0987 | djy | 1 | 1 | 2026 -Week 21 | 80.00% |
| TYUI0987 | yjdy | 1 | 0 | 2026 -Week 21 | 80.00% |
| TYUI0987 | dyjdd | 1 | 0 | 2026 -Week 21 | 80.00% |
| QQQQQ123 | dtyjt | 1 | 0 | 2026 -Week 22 | 100.00% |
| QQQQQ123 | djdtjy | 1 | 0 | 2026 -Week 22 | 100.00% |
| QQQQQ123 | dtjyd | 1 | 0 | 2026 -Week 22 | 100.00% |
| QQQQQ123 | tejyej | 1 | 0 | 2026 -Week 22 | 100.00% |
| GFRT678 | tyj | 1 | 1 | 2026 -Week 22 | 0.00% |
| GFRT678 | tdjy | 1 | 1 | 2026 -Week 22 | 0.00% |
| GFRT678 | jtydjyd | 1 | 1 | 2026 -Week 22 | 0.00% |
| GFRT678 | dyjtdjd | 1 | 1 | 2026 -Week 22 | 0.00% |
| TYUI0987 | dtjydj | 1 | 1 | 2026 -Week 22 | 40.00% |
| TYUI0987 | eue56udtj | 1 | 1 | 2026 -Week 22 | 40.00% |
| TYUI0987 | tyjejdj | 1 | 0 | 2026 -Week 22 | 40.00% |
| TYUI0987 | djydjd | 1 | 0 | 2026 -Week 22 | 40.00% |
| TYUI0987 | dtyjdj | 1 | 1 | 2026 -Week 22 | 40.00% |
| QQQQQ123 | hgncgyt | 1 | 0 | 2026 -Week 23 | 100.00% |
| QQQQQ123 | 56u7 | 1 | 1 | 2026 -Week 23 | 100.00% |
| QQQQQ123 | ghm | 1 | 0 | 2026 -Week 23 | 100.00% |
| QQQQQ123 | yuk6r | 1 | 1 | 2026 -Week 23 | 100.00% |
| GFRT678 | mchm | 1 | 0 | 2026 -Week 23 | 100.00% |
| GFRT678 | r67ik | 1 | 1 | 2026 -Week 23 | 100.00% |
| GFRT678 | tykjdgm, | 1 | 1 | 2026 -Week 23 | 100.00% |
| GFRT678 | 67i6 | 1 | 1 | 2026 -Week 23 | 100.00% |
| TYUI0987 | 6r7i86 | 1 | 1 | 2026 -Week 23 | 100.00% |
| TYUI0987 | mfghmr | 1 | 0 | 2026 -Week 24 | 100.00% |
| TYUI0987 | rkrukf | 1 | 0 | 2026 -Week 24 | 100.00% |
| TYUI0987 | r7krmf | 1 | 0 | 2026 -Week 24 | 100.00% |
| TYUI0987 | mfghmryu | 1 | 1 | 2026 -Week 24 | 100.00% |
| QQQQQ123 | r67iir | 1 | 0 | 2026 -Week 24 | 100.00% |
| QQQQQ123 | r67kir | 1 | 0 | 2026 -Week 24 | 100.00% |
| QQQQQ123 | mfkjm | 1 | 1 | 2026 -Week 24 | 100.00% |
| QQQQQ123 | 67irkjf | 1 | 0 | 2026 -Week 24 | 100.00% |
| GFRT678 | fkmfgm6r7i | 1 | 0 | 2026 -Week 24 | 100.00% |
| GFRT678 | r67iir | 1 | 0 | 2026 -Week 24 | 100.00% |
| GFRT678 | r67i6i4i | 1 | 0 | 2026 -Week 24 | 100.00% |
is this what you want?
column =Var _stock=CALCULATE(sum('Table'[RCVD STOCK]),ALLEXCEPT('Table','Table'[Group],'Table'[% WEEKLY]))var _count=CALCULATE(sum('Table'[COUNT]),ALLEXCEPT('Table','Table'[Group],'Table'[% WEEKLY]))return DIVIDE(_count-_stock,_count)
4 Replies
is this what you want?
column =Var _stock=CALCULATE(sum('Table'[RCVD STOCK]),ALLEXCEPT('Table','Table'[Group],'Table'[% WEEKLY]))var _count=CALCULATE(sum('Table'[COUNT]),ALLEXCEPT('Table','Table'[Group],'Table'[% WEEKLY]))return DIVIDE(_count-_stock,_count)Hi ryan_mayu yes and thank you very much. all goods
you are welcome
% WEEKLY =
VAR _total =
CALCULATE(
COUNTROWS('Table'),
ALLEXCEPT('Table', 'Table'[Group], 'Table'[Year Week Column])
)
VAR _rcvd =
CALCULATE(
SUM('Table'[RCVD STOCK]),
ALLEXCEPT('Table', 'Table'[Group], 'Table'[Year Week Column])
)
RETURN
DIVIDE(_rcvd, _total)If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
