Power Query – Sum only Numbers in a List – Tips & Tricks 13

Suppose you are given a list {"x", "100","200", "x300", 500} and you need to sum only the numbers 100, 200 and 500 in it. Then you can use following code

= List.Sum(List.Transform({"x", "100","200", "x300", 500}, (x)=> 
if Value.FromText(x) is number then Value.FromText(x) else 0 ))