Forum Discussion
Column value from row
Hi deaconb
There are many ways to achive your required output, and one example is as shown below:
I attach an example pbix file.
Hi deaconb
Hope this is what you're looking for
Table 2 =
SUMMARIZE (
'Table',
'Table'[ResponseID],
"Trainee", MAXX ( FILTER ( 'Table', 'Table'[Role] = "Trainee" ), 'Table'[Name] ),
"Trainer", MAXX ( FILTER ( 'Table', 'Table'[Role] = "Trainer" ), 'Table'[Name] )
)hey - this result is exactly what I'm looking for. However, when I insert it into my query as a column, it gives me an error of a cyclic reference.
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.
