I have created a column in my model using "Insert Text before delimiter":
Table.AddColumn(#"Changed Type", "Text Before Delimiter", each Text.BeforeDelimiter(Text.From([Project ID], "en-GB"), "."), type text)
Partly the result is blank. In this case, I would like to have the value from column [opportunity code] in this table.
I have no idea how to get this working. Please help. Thanks in advance.