get the last digit of a number

[Anonymous]

How can i get the last digit of 89827460?

I wanto to check the last digit  of the value of a column and if it is 0 return "A" if 1 return "B" if 3 return "C".

[Vijay_A_Verma]

= if Text.End([Data],1)="0" then "A" else if Text.End([Data],1)="1" then "B" else if Text.End([Data],1)="2" then "C" else null

Please whether you need C for 2 as you are saying it is needed for 3.

[smpa01 · Accepted solution]

@Anonymous  try this

let x = Text.End(Text.From([Column1]),1)
in if x="0" then 1 else if x="1" then 2 else if x="3" then 3 else -999