Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/Number.DEC2BIN.m

Forked from IvanBond/Number.ToBinaryString.m
Last active March 15, 2017 17:30
Show Gist options
  • Save Hugoberry/155766c5dfde9c7aeef291d1907c3be9 to your computer and use it in GitHub Desktop.
Save Hugoberry/155766c5dfde9c7aeef291d1907c3be9 to your computer and use it in GitHub Desktop.
Download ZIP
DEC2BIN or HEX2BIN in Power Query M
Raw
Number.DEC2BIN.m
(num as number)=>
List.Last(
List.Generate(
() =>[reminder = num,
binString= Number.ToText(Number.BitwiseAnd(reminder,1))],
each [reminder]> 0,
each [reminder = Number.BitwiseShiftRight([reminder],1),
binString= Number.ToText(Number.BitwiseAnd(reminder,1))&[binString]],
each [binString]
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment