Forum Discussion
How to map two data sets in a data model
Take a look at this article from DAX Patterns on survey data. https://www.daxpatterns.com/survey/
You have a good start with your second table, I think you just need to organize your responses table vertically.
Basically, the pattern is, each question / answer pair is assigned an unique answer key.
Finance Organizational Evaluation / N/A is 1
Finance Organizational Evaluation / Beginner is 2
Cost Take Out / Beginner is 22
Cost Take Out / Experienced is 23
Cost Take Out / Advanced is 24
etc.Then you map the answer keys to the employee based on thier responses.
It's all covered in that article.
Take a look at this article from DAX Patterns on survey data. https://www.daxpatterns.com/survey/
You have a good start with your second table, I think you just need to organize your responses table vertically.
Basically, the pattern is, each question / answer pair is assigned an unique answer key.
Finance Organizational Evaluation / N/A is 1
Finance Organizational Evaluation / Beginner is 2
Cost Take Out / Beginner is 22
Cost Take Out / Experienced is 23
Cost Take Out / Advanced is 24
etc.
Then you map the answer keys to the employee based on thier responses.
It's all covered in that article.
this works! thank you!