Forum Discussion
DATA MODEL
Hello,
I have 4 facts table and have this model as follows:
Table 1
Key Index
- Emp No
- Hire Date
- Termination Date
Table 2
Key Index
- Emp No
- Date
Table 3
Key Index
- Emp No
- Date
Table 3
Key Index
- Emp No
- Date
Calendar
- Date
below is the diagram for easy understanding.
My question is how can i link table 2 [date] , table 3 [date] and table 4 [date] to calendar[date] keeping star schema model.
Or is there a way to do measure keeping table 1 related to calendar and not table 2,3 and 4?
Thanks for your help.
Regards,
11 Replies
- camargos88Community Champion
Hi CJ_96601 ,
Can't you just use 1 Emp table (append them)...
Also, why do you need those 3 tables, once you have the data on table 1 ?
Ricardo
- CJ_96601Helper V
Hello camargos88
Thank you for your response.
Tables are from our ERP via ODBC. I tried append but refresh takes forever.
Is there any other solution, until append is fix.
Regards,
- camargos88Community Champion
- jstormResolver III
Post a screenshot of your 'Model' tab in Power BI.