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.
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.