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