Forum Discussion

Icon for Helper V rank

Helper V

6 years ago

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

Icon for Helper V rank

Helper V

6 years ago

can you elaborate, please

Icon for Community Champion rank

Community Champion

6 years ago

Why don't you submit a query to your source like:

TABLE 1 UNION ALL TABLE 2 UNION ALL TABLE 3....

Also, check this link, maybe it's gonna help with your model:

https://radacad.com/directquery-live-connection-or-import-data-tough-decision

Ricardo

CJ_96601
Helper V
6 years ago
camargos88

It is not that easy...considering how oracle is .

thanks for the link.
- camargos88
  Community Champion
  6 years ago
  CJ_96601 ,
  
  Once you have the queries, you can go to Advanced Mode e write your custom query:
  - CJ_96601
    Helper V
    6 years ago
    camargos88
    
    I will try this once things get back to normal and revert.
    
    I have no VPN at the moment and lockdown is in place...
    
    Thanks
- CJ_96601
  Helper V
  6 years ago
  camargos88
  
  On another note, i know this is not related to my previous question, please refer to the screen shot below:
  
  Why bar graph ended up that way , when using below measure?
  
  CALCULATE(DISTINCTCOUNT(ODBC[EMPNO])+0,
  USERELATIONSHIP(ODBC[TERMDATE], 'Calendar'[Date]),
  not(ISBLANK(ODBC[TERMDATE])+0),
  
  ODBC[REASON]="TRANSF") - // THIS SUPPOSE TO FILTER
  
  Secondly, can i use "<= CALENDAR[DATE]" with the above measure?
  
  Regards,
  - camargos88
    Community Champion
    6 years ago
    CJ_96601 ,
    
    It looks like a problem with your model design, check the table connections.
    Would help if you post how you are connections those tables. But try to be simple with the model, redesign it with the append ou union.
    
    Ricardo