Remove the rest of the data after first occurence

[Anonymous]

I have concatenated few columns since my data was too great calculation wise, for which the DAX could not calculate as it was too complex, So I have to split the data into pieces and concatenate with & operator.

However the problem is that if there are more than 1 occurence for the same GPS location, the concatenated row shows data from both column. I am only interested in 1 of the column name to be present. 

So the question is, is there a way to remove any other occurence with starting name "Balise" after the first occurence. 

Example: if the data is as: "Balise: BRA2154vBalise: BY1154v"  it should be just "Balise: BRA2154v", so only 1 occurence is present at a time. 

[v-chuncz-msft]

@Anonymous ,

You may try the custom column below.

List.First(List.Select(Record.ToList(Record.RemoveFields(_, {"Column1", "Column2"}, MissingField.Ignore)), each _ <> ""), 1)

[Anonymous]

@v-chuncz-msft 

Perhaps I did not mention, but the problem is not in power query. Cause if it was in the query, I could just use the function Power Bi provides already.

That is why using List.First will show in gray if used outside the Power query, as it is not m-script I believe.

Thank you for your effort 🙂