Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

conditionally replacing values

Hi   I read in a blog that you can conditionally replace values in a column.   = Table.ReplaceValue(#"Filtered Rows",each [CATEGORY DETAIL],each if ([CATEGORY]="CAR" and Text.Contains([PRODUCTS],...
Show and Tell
Tips and Tricks
Tutorial Requests
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi Anonymous ,

    syntax looks alright to me at first sight.
    Please be aware that Power Query is case sensitive.

    Also, you could try the change the replacer function from Replacer.ReplaceText  to Replacer.ReplaceValue.

    Also, make sure to clean and trim the CATEGORY-column.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler I don't think so. It worked in another dashboard with the exact same syntax which is why I am wondering that power bi doesn't replace the values accordingly nor returns an error