Forum Discussion
Parsing real time data
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
1 Reply
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
