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.

     

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

I have done test with the data and M code you provided. It works well.

Is the dashboard working well a live page pinned to it and the one with no changes a visual pinned it?

 

Best Regards,

Caiyun Zheng