Forum Discussion
Solved
division into even and odd
Dear Colleagues,
Looking for ideas how to create calculated columns which can represent results in the folowing way
| Date | Customer | Product | Product ID | Customer Order Nr | Number of Carriers | Calculated Column |
| 02-03-18 | Customer A | Product A | 10001 | 20001 | 1 | 1 |
| 02-03-18 | Customer A | Product A | 10001 | 20001 | 1 | 0 |
| 02-03-18 | Customer A | Product A | 10001 | 20001 | 1 | 1 |
| 02-03-18 | Customer A | Product A | 10001 | 20001 | 1 | 0 |
| 02-03-18 | Customer A | Product A | 10001 | 20001 | 1 | 1 |
| 02-03-18 | Customer A | Product A | 10001 | 20001 | 1 | 0 |
| 03-03-18 | Customer B | Product B | 10002 | 20002 | 1 | 1 |
| 03-03-18 | Customer B | Product B | 10002 | 20002 | 1 | 0 |
| 03-03-18 | Customer B | Product B | 10002 | 20002 | 1 | 1 |
| 03-03-18 | Customer B | Product B | 10002 | 20002 | 1 | 0 |
- You can do this using Power Query Editor.
Add an index column starting at 1. Then transform this using standard > modulo with a divisor of 2.
1 Reply
- You can do this using Power Query Editor.
Add an index column starting at 1. Then transform this using standard > modulo with a divisor of 2.