Forum Discussion
Data model Creation
Hi ALL I have two tables like below Table 1 Table 2 By using these two tables How can I create a data model like below image? Final Data Model Data: Interview ...
Hi Anonymous,
I would suggest you create a new table in your scenario. The slicer Candidate will be from it.
CandidateIDs = DISTINCT ( UNION ( VALUES ( Table1[Candidate ID] ), VALUES ( Table2[Candidate ID] ) ) )
Best Regards,
Thanks v-jiascu-msft
in the data model, I want to update Table 2 (Interview Round) like below image
I want to add the registered date in this table, then only I can complete my requirement
Requirement
- How many candidates registered on the selected date? and drill down to their personal information and interview result
- How many candidates attend the interview on the selected date? and drill down to their personal information and interview result
How can i achieve this logic? please give some idea to complete this requirement
Hi Anonymous,
These data is in Table 1. Why would you like to add them in Table 2? I would suggest you keep the model simple and clear.
You need to add a date table. Then you can solve the two questions using measures.
Best Regards,