Forum Discussion

Helper I

2 years ago

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

Need Help

Show and Tell

Tips and Tricks

DataNinja777
2 years ago
Hi deaconb

There are many ways to achive your required output, and one example is as shown below:

I attach an example pbix file.
Trainer Trainee database.pbix19 KB

DataNinja777

Super User

2 years ago

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.