Power Query Function for Custom Column

[Sowmiya]

Hi Community,

I need a Custom Column whereas

     Index Column=1 then Custom = 1,

     Index Column=2 then Custom = 2,

     Index Column=3 then Custom = 3,

     Index Column=4 then Custom = 1,

     Index Column=5 then Custom = 2,

      Index Column=6 then Custom = 3 and so on.
Please do favour if you would help me

[LivioLanzo · Accepted solution]

Use this function: https://docs.microsoft.com/en-us/powerquery-m/number-mod

or via the UI

[Zubair_Muhammad · Accepted solution]

Hi @Sowmiya

Try this custom Column

=if Number.Mod([Index],3) = 0 then 3 else Number.Mod([Index],3)

[LivioLanzo · Accepted solution]

Use this function: https://docs.microsoft.com/en-us/powerquery-m/number-mod

or via the UI