Forum Discussion

Nelleke-NL's avatar
Nelleke-NL
Icon for Helper II rankHelper II
3 years ago

copy column to other query

I'm very glad with the solutions to work with answers on multiply answer-question previous question    But in the complete table there are several columns/questions like this.  Name  anwers a...
Need Help
Show and Tell
Tips and Tricks
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Nelleke-NL 

Can you show the expected result? I don't quite understand the requirements from your explanation

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

  • Nelleke-NL's avatar
    Nelleke-NL
    Icon for Helper II rankHelper II
    3 years ago

    I'll try *English is difficult for me

    = Table.AddColumn(#"Type gewijzigd1", "Q1 new", each Text.Split([q1],";"))

    = Table.AddColumn(#"Aangepaste kolom toegevoegd", "Q1 new", each Text.Split([q1],";"))

    = Table.AddColumn(#"Aangepaste kolom toegevoegd", "Q2 new", each Text.Split([q2],";"))

    Removed Q1 and Q2

    = Table.ExpandListColumn(#"Kolommen verwijderd", "Q1 new")

    report:

    Huh How can I count like Q1 new? Other tabel? Or is there a nicer solution?