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

Anonymous's avatar
Anonymous
Not applicable
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am new to Power BI, although I have been working with Power Query in Excel for some time. I realize that rajendran's post was from several months ago, but I do appreciate the simplicity of his proposed solution. In response to similar questions posted elsewhere, I have typically read suggestions to duplicate the query and apply different criteria for each copy of the query. For small datasets, this might be workable. But for large datasets, duplicating that data pull repeatedly is very inefficient. rajendran's solution requires only a single data pull, which to me seems the most-efficient way to perform this kind of task. And I learned something new, which is also a plus! :smileyhappy:

    • Gazzer's avatar
      Gazzer
      Resolver II
      7 years ago

      Anonymous Totally agree - Anonymous's solution was much better than mine, and I learned something new too. This is why getting involved with the forum is a good thing - sometimes you find the way you do things is good; sometimes someone shows you how to do it better.