Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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)))
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".
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)))