Forum Discussion
Streaming Dataset (Forms) - Measure to separate Multiple choice responses
Hello! We created a streaming dataset for a Microsoft Forms Survey and some of the responses can be multiple choices. I need to create a measure to separate each text/string value, it appears it is a JSON string. Is there a way to separate each text in the string?
2 Replies
In the query editor you can add a custom column that uses this expression
= List.Transform(Text.Split([TextColumn], ","), each Text.Select(_, {"a".."z", "A".."Z"}))
This will result in a List which you (by hitting the double arrow button at the top of the column) can either Extract Values or put the names on new rows.
Regards,
Pat
Hello! Thanks for the prompt response and info. I am unable to access Query Editor with the streaming data with the API for Microsoft Forms. Do you know why this is?
This is the method being used to create this https://flow.microsoft.com/en-us/blog/forms-and-flow-and-powerbi/
