Forum Discussion
Solved
Group by or Filter sum rows
Hi Guys,
I need these columns
| ID&Product | Total Days |
| 111Books | 15 |
| 111Cars | 15 |
| 111Bike | 20 |
| 222Bike | 55 |
| 222Cars | 75 |
from this table
| ID | Product | ID&Product | Days |
| 111 | Books | 111Books | 5 |
| 111 | Books | 111Books | 10 |
| 111 | Cars | 111Cars | 15 |
| 111 | Bike | 111Bike | 20 |
| 222 | Bike | 222Bike | 25 |
| 222 | Bike | 222Bike | 30 |
| 222 | Cars | 222Cars | 35 |
| 222 | Cars | 222Cars | 40 |
Thanks
Sorted, using real data
Test = if(DeliveryExtract[Week Number] = DeliveryExtract[Week From],SUMX(VALUES(DeliveryExtract[ProjectID & Product Key]),CALCULATE(SUM(DeliveryExtract[Actual Time + ETC (Days)]))))
1 Reply
Sorted, using real data
Test = if(DeliveryExtract[Week Number] = DeliveryExtract[Week From],SUMX(VALUES(DeliveryExtract[ProjectID & Product Key]),CALCULATE(SUM(DeliveryExtract[Actual Time + ETC (Days)]))))