Forum Discussion
Solved
Column value from row
We have training data that looks like below: Name Role ResponseID Trainer A Trainee 7125417 Z Z Trainer 7125417 A Trainee 7125461 Y Y Trainer 7125461 B Tr...
Hi deaconb
There are many ways to achive your required output, and one example is as shown below:
I attach an example pbix file.
The source data is a full dataset of training information. I truncated the data in my example to only the columns I care about/need to work with.
When I applied your logic as a Custom Column step in Power Query, I received this error:
Expression.Error: A cyclic reference was encountered during evaluation.
When I applied your logic as a new Column in Power BI table view, I received this error:
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.