Power Query - Help

[NiharikaRaghav]

Hi All,

I have a columns with header "Sales Q2 vs Q3 ("Sales values")". I have to replace this column null values with 0.

I tried using Text.Contains(_,"Sales values") and Replace but it didn't work. 
Need help on this. So, basically I want to replace null values with 0 of all the columns whose column header contains "Sales Values" keyword . I want to do this in Power Query.

Thank You.

[NiharikaRaghav]

Thanks @Vijay_A_Verma , it worked.

And what if I want to pivot this column , i mean pivot column if column header contain "Sales Values".

[Vijay_A_Verma · Accepted solution]

Insert this step where #"Changed Type" in 2 places need to be replaced with your previous step name

Table.ReplaceValue(#"Changed Type", null, 0, Replacer.ReplaceValue,List.Select(Table.ColumnNames(#"Changed Type"), (x)=> Text.Contains(x, "Sales Values", Comparer.OrdinalIgnoreCase)))