Replace all Numbers with null

[JackDanIce]

Hi,

I'm stuck trying to code: If [Label] does not contain ".0" Then [Sum] = null, Else [Sum] = [Sum]

{Sum] contains null or whole numbers only, range -100 to 10 (Max always 10, potential minimum -infinite, -100 as proxy)

This works only for -8

=Table.ReplaceValue(#"Filter Rows", -8, null, Replacer.Replace.ReplaveValue,{"Sum"})

This works for whole numbers (not tested for > 9)

=Table.ReplaceValue(#"Filter Rows", {0..9}, null, Replacer.Replace.ReplaveValue,{"Sum"})

But doesn't work for negative numbers (I tried {-9..9} as well)

Ultimately, I'm trying to achieve

"Each If [ColA] does not contain ".0" Then Null Else [Sum]"

But can't figure out the M code

TIA,
Jack

 

[Alex Blakenburg]

Is [Label] a text column and is [Sum] a column ?
If that's the case why not just use Add Column > Conditional Column

= Table.AddColumn(#"Renamed Columns", "NewColumn", each if not Text.Contains([Label], ".0") then null else [Sum])

 

[JackDanIce]

Hi, I discovered this later and it does work, thank you for suggesting

 

[Alex Blakenburg]

Thanks for letting me know. Happy to help.