Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Assemble equal data after using the function Table.ReplaceValue

Hello,   In my dashboard I wrote a formula in Power Query to replace values according to two conditions like the example below: if it is an orange in France, then replace the orange by an apple. ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    In addition to bcdobbs 's reply, please try Trim function in Power Query.

    Here I have a test by add space front or behind "Apple". We can see there are three Apples which look like the same in Filter. 

    I find Clean function couldn't remove them. Try trim, it will work.

    Or find all different "Apples" by filter , copy them and compare them to find the difference.

    For reference: Trim Vs Clean in Power BI and Power Query

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , There is a clean option in the transform tab in power query, use that on this field and check

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello amitchandak, I tried this solution by clicking on "Transform > Clean" but it didn't work. Do you have another idea ? 

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,
    Can you a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Unfortunaltly I can't, all data are sensitive