Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ente...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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