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
There are many ways to achive your required output, and one example is as shown below:
I attach an example pbix file.
Hi DataNinja777 this works as a new Column in Power BI table view, but it isn't working as a Custom Column step in Power Query (I understand they are different).
I'd prefer to do this in Power Query so I can then delete the "Trainer" row all togther, after the new column is created, which makes the remaining dataset 50% less rows as the only difference between the raw dataset rows is the Trainer row and Trainee row.
Do you know what modifications I'd need to make to get this to work through Power Query?
Hi deaconb
You have your required output in dax formula from multiple people, but if you want to use Power Query instead, you can create a table like below using Power Query Ribbon clicking technique.
Best regards,
Thanks. I'll just use the dax output.