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

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