How to merge to data in one table

[RickyTWK]

Hello, I work from construction company.

I would like to create a dashboard to report the issues status by each month.

How can merge two excel data in one table?  What is the workflow and skill.... 

Thank you so much!

[Kishore_KVN · Accepted solution]

Hello @RickyTWK ,

Follow below steps to achieve it. 

1. In power query editor, using append queries you can combine data of two different months.

2. In Power BI Desktop, you can use stacked bar chart to represent month wise. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Kishore_KVN · Accepted solution]

Hello @RickyTWK , 

For the count you have to take distinct count in the card visual which will survive your requirement. But always belive there will be duplicates in the ID as its a monthly activity. So add a date column in each table before appending so that you will get dates and you can filter them using slicer in Power BI Desktop. 

[Kishore_KVN · Accepted solution]

Hello @RickyTWK ,

Follow below steps to achieve it. 

1. In power query editor, using append queries you can combine data of two different months.

2. In Power BI Desktop, you can use stacked bar chart to represent month wise. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[RickyTWK]

Thanks @Kishore_KVN , You help me a lots!

I have the last question. The date data was show wrong.

My excel data is generated automatically and it is mm/dd/yy. 

However, I can't find mm/dd/yy in powerBI . The visual table was shown the wrong month in the result. 

How can fix it? Thanks!

[Kishore_KVN]

Hello @RickyTWK 

In this case, select the month column in Power Query Editor and click on data type then select Using Local option then select date time as per your region or your system date time then this will help you to select proper date format. 

[RickyTWK]

It's works!! Thank you so much. 

[RickyTWK]

Thanks your reply, @Kishore_KVN

In first step, I created a new table from append two current table. However, the issues numbers were duplicated once.   Is it possible to merge the duplicated item?  I want the total issues number is 160 finally.

Thanks your help!