Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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] ) )
)

    Data-model-Creation2

    Data-model-Creation3

     

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

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,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-jiascu-msft

 

pbix file

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 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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] ) )
)

    Data-model-Creation2

    Data-model-Creation3

     

     

    Best Regards,