Adding categories from different sheets of Power BI

[Anonymous]

Hi All, 

I have similar catergories in different Power BI sheets. I was hoping if there is a way to add them all. Also, adding them in a way so that it gets separated by year and month. Year and Month are in another columns. For example:

Column1 (Catergory)    Column 2 (year)     Column 3 (Month)

1. AAA                            1. 2019                   1. JAN

2. BBB                             2. 2019                   2. JAN

3. CCC                            3. 2019                   3. FEB

4. AAA                            4. 2019                   4. March

5. CCC                            5.2019                     5. April

This is similar in all the sheets. Any help is much appreciated. Thanks!

Gaurav Paul

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at Combine binaries and Append Queries (Table.Combine) in Query Editor.