Parsing real time data

[Anonymous]

My data source is coming from MS Forms, containing questions.  User responses can have multiple values within a single response.  For example:

employee 1 can enter location 1

employee 2 can enter location 1, location 2

This location data appears in a single column as

location 1;

location 1; location 2;

With the use of Flow, this data is automatically populating Power BI, but how can I parse the location data so that each value is on a separate row such as:

employee 1     location 1

employee 2     location 1

employee 2     location 2

[amitchandak]

One option is

https://radacad.com/pivot-and-unpivot-with-power-bi

Second

union(			
summarize(filter(table,not(isblank(table[location1]))),table[employee],table[location1]),
summarize(filter(table,not(isblank(table[location2]))),table[employee],table[location2])
)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin