Forum Discussion

murt112's avatar
murt112
New Member
9 years ago
Solved

Splitting a table into two based on column value

Hi!   I'm fairly new to PowerBI and have slowly been experimenting with different functions but I've sort of hit a dead end with this. I have a master excel file that is populated with data month o...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi murt112,

    In Query Editor of Power BI Desktop, right click master query and then choose “Duplicate” as shown in the following screenshot.


    Filter year to 2015 in the first duplicated query and filter year to 2016 in the second duplicated query.


    And you can also rename the first duplicated query to 2015 and another to 2016.

     

    Thanks,
    Lydia Zhang

SQLMonger's avatar
SQLMonger
Advocate II
7 years ago

Even simpler: Use the query "Reference" feature. 

 

In the query panel on the left, right-click on your original import from Excel and clear the check box for "Enable Load", then right-click on it again and select "Reference". This will create a new query that references the first. Apply your year filter to the new query, rename the query and repeat as needed.

 

Warm regards,

 

Clayton

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Jut what I was looking for... You are a savior!