Forum Discussion
Solved
Create a calculated column from another text column
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.
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.
1 Reply
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.