Create a calculated column from another text column

[roman_gorbunov]

Good day,

there is such a table structure of 2 columns - VIN and Insurance Type

we have a list of cars that have different types of insurance. One car can have several types of insurance. I need to create a calculated column (insurance type_summarized_by_vin) that contains comma separated all types of insurance applied to a given car. If instead of the string type of insurance there was a number, then I would use the allexcept function with sum/avr... inside calculate, but here is the text. Any ideas? Thanks in advance for any help.

[jppv20 · Accepted solution]

Hi @roman_gorbunov ,

Try this:

insurance type_summarized_by_vin = CALCULATE(CONCATENATEX('Table','Table'[insurance_type],","),ALLEXCEPT('Table','Table'[VIN]))

If I answered your question, please mark it as a solution to help other members find it more quickly.