Alternate number based on group

[GoatTracker]

I'm looking to format the POWER QUERY table by group instead of by row.  My Code references are sorted in the query, how can I apply a new column like the example below?

Code	Group
ABC123	1
ABC126	0
FFR556	1
KKI998	0
WWA324	1

[olgad · Accepted solution]

Hi, how many codes you have, is there any logic in assigning group 1 or group 0? Conditional column will help you to create this column, 

if it is 1 for the first row then 2 for the second 1 for the 3rd, 2 for the 4th then
add index column first then custom column
if (Number.IsEven([Index])=true) then 0 else 1

Appreaciate your kudos and acceptance of the solution if it works for you.

[GoatTracker]

Hi @olgad I have hundreds not in sequential order unfortunately.

[olgad · Accepted solution]

if index column and custom column 
if (Number.IsEven([Index])=true) then 0 else 1
is not an option, then please identify the logic based on which you want to assign group 1 group 0?

[olgad · Accepted solution]

Hi, how many codes you have, is there any logic in assigning group 1 or group 0? Conditional column will help you to create this column, 

if it is 1 for the first row then 2 for the second 1 for the 3rd, 2 for the 4th then
add index column first then custom column
if (Number.IsEven([Index])=true) then 0 else 1

Appreaciate your kudos and acceptance of the solution if it works for you.