Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Prefiltering table with VAR referencing to another table?

Hi all,   I have an AIRCRAFT table which contains data of when each aircraft starts and finishes operating for my company. If you notice, aircraft CCC starts operating later than AAA and BBB. This ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Create relationship as below

     

    Create calcuated columns in 'UTILIZATION' table

    related_start = RELATED(AIRCRAFT[start])

related_start = RELATED(AIRCRAFT[start])

filter_column = IF([date]>=[related_start]&&[date]<=[related_end],1,0)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

Create relationship as below

 

Create calcuated columns in 'UTILIZATION' table

related_start = RELATED(AIRCRAFT[start])

related_start = RELATED(AIRCRAFT[start])

filter_column = IF([date]>=[related_start]&&[date]<=[related_end],1,0)

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-juanli-msft,

     

    Thank you very much for your prompt reply.

     

    It's indeed a very simple solution but I hadn't come accross the RELATED formula.

     

    I guess this might decrease performance as I'm adding two more calculated columns, but it seems to work perfectly. I will have to implement it in the real case but I don't think there should be any other problems rising from this.

     

    Thanks again and regards!