Forum Discussion

roman_gorbunov's avatar
roman_gorbunov
Frequent Visitor
4 years ago
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 n...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    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.
jppv20's avatar
jppv20
Solution Sage
4 years ago

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.