cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mrslyfox Regular Visitor
Regular Visitor

division into even and odd

Dear Colleagues,

 

Looking for ideas how to create calculated columns which can represent results in the folowing way

DateCustomerProductProduct IDCustomer Order NrNumber of CarriersCalculated Column
02-03-18Customer AProduct A100012000111
02-03-18Customer AProduct A100012000110
02-03-18Customer AProduct A100012000111
02-03-18Customer AProduct A100012000110
02-03-18Customer AProduct A100012000111
02-03-18Customer AProduct A100012000110
03-03-18Customer BProduct B100022000211
03-03-18Customer BProduct B100022000210
03-03-18Customer BProduct B100022000211
03-03-18Customer BProduct B100022000210

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Lind25 Regular Visitor
Regular Visitor

Re: division into even and odd

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 1
Lind25 Regular Visitor
Regular Visitor

Re: division into even and odd

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.