Forum Discussion
deaconb
Helper I
Helper IColumn 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...
tamerj1
Community Champion
Community ChampionHi 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] )
)
deaconbHelper I
Helper Ihey - 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.
- deaconb
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.