Forum Discussion
Help with looking up multiple values in different columns and combining results
We can use Edit Queries to get the result. Show the steps as below:
1. Choose ‘WorkItemID’ column and use ‘Unpivot Other Columns’
2. Merge the two queries you needed
3. Remove the columns which are not needed
4. Group by the workitemid to sum the value of name in UserID table
5. Change the M language from each List.Sum([UserID.Name]) to each Text.Combine([UserID.Name],",")
For more information, please refer to the pbix as attached.
We can use Edit Queries to get the result. Show the steps as below:
1. Choose ‘WorkItemID’ column and use ‘Unpivot Other Columns’
2. Merge the two queries you needed
3. Remove the columns which are not needed
4. Group by the workitemid to sum the value of name in UserID table
5. Change the M language from each List.Sum([UserID.Name]) to each Text.Combine([UserID.Name],",")
For more information, please refer to the pbix as attached.
v-chuncz-msft Awesome, thanks for the help!