Forum Discussion

inbal's avatar
inbal
Regular Visitor
8 years ago
Solved

Split Query for Tables

Hey, I wanted to ask if there is a query that allows a dynamic distribution of two tables? Similar to the "append" query. I am aware of the option of "duplicate a table" and then making a suitab...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    You can try this in DAX as well.

     

    In Modelling -> New Table

     

    Child_TableA= FILTER ( Parent_table, Parent_Table[Project] = 1)

     

    Child_TableB= FILTER ( Parent_table, Parent_Table[Project] = 2)

     

    In this way, you will have 2 dynamic child tables .

     

    Hope this helps.

     

    Thanks
    Raj

Gazzer's avatar
Gazzer
Resolver II
8 years ago

You seem to already have the answer you need.

 

You could either dupliacate parent and filter one for project 1 and the other for project 2 (essentially, exactly what you said you are already aware of!).

 

Otherwise, you could reference the parent table twice, and do the same filtering on both referencing queries.

 

I'm struggling to see why these are not suitable options - perhaps more information is needed?