Merging fields and grouping within fields

Hi Anonymous, 

If the parent grouping isn't available in the source data then you could add a conditional column.

That has potential to not be a very dynamic solution depending on how changable the data is, so be careful if you go down this path.

The other way to do it outside of Power Query is to use the Group function. 

In the field list, right click on the field you want to group and click 'New Group'. You will then get the dialogue shown below which I think will be familiar to you.

Hope that helps.

Kim

Hi Anonymous ,

1)

You can depulicate your table to create a transformationtable with the [From] column and [To] column and create a custom column in the source table to do the fuzzy match:

= Table.AddFuzzyClusterColumn(
        #"Changed Type",
        "Origin Station",
        "New",
        [
            IgnoreCase = true,
            IgnoreSpace = true,
            TransformationTable = Transformationtable
        ]
    )

Keep this new column and remove duplicates in it:

You can also refer this articles about fuzzy match:

1. Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold 
2. Table.AddFuzzyClusterColumn 

2) You can refer @ KNP suggestion to do the group in power query.

 Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.