Forum Discussion
Data model Creation
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,
when I select 01/02/2019 it shows the correct result
when I select candidate ID it shows the wrong result
1) interview result table did not filter based on candidate selection
2) I have selected C1 candidate in Personal Information table, it wants to drill down to his interview result in drill down page
Data model
I'm new to Power PI, Please help me to solve this issue
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,