Forum Discussion

Lmendes's avatar
Lmendes
Frequent Visitor
8 years ago
Solved

Delimiter at each instance of an integer

Hi I have some concatenated data i.e. 1=Married 2=Single 3=In a sexual relationship 4=Widowed 5=Divorced / Separated 6= Cohabiting   I want to split out into seperate columns. I want to spl...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Lmendes,

     

    You can refer to below sample to transform QA table in query editor and use dax formula to lookup related answers.

     

    Regards,

    Xiaoxin Sheng

Lmendes's avatar
Lmendes
Frequent Visitor
8 years ago

Hi

Thanks for your help so far. I tried your solution but again i get this error (because the data is a mix of text & Int64). I need to keep both the text and the numbers as i need to know what each number relates to for each question.

 

Thank you

Laura

 

Expression.Error: We cannot convert a value of type List to type Text.
Details:
    Value=List
    Type=Type

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lmendes It would make it lot easier if you can provide more details by sharing the power bi file you created. Else it is like shooting in the dark trying to guess where you are failing.