How merge the two table

[Sudhakar1000]

Hi,

I have two different Year table 2324 & 2425, So i need to bring both table values in single Table with same format, when i am trying merge from 2324 table other then matching details getting ingored , if i will Append 2324 table values only reflecting so can you Some one help me any other way to connect table

Append table

[AllisonKennedy · Accepted solution]

@Sudhakar1000  What is the result you want? If you want to stack the 2324 table and 2425 table on top of each other, you need to ensure they have the same format, and then use the 'Append' option. Both tables must have the same column names. 

From there, you can Remove duplicates or Group By to ensure the matching records are ignored. 

[Sudhakar1000]

Hi Allison,

Thank you for replying , 

Also i am looking the result like below 

[v-linyulu-msft]

Thanks for the reply from AllisonKennedy  please allow me to provide another insight:

Hi, @Sudhakar1000 

Based on the information you’ve provided so far, we are unable to understand, particularly the “achievement” column in your expected results. We did not observe the values for this column in the screenshots you previously provided.I would be grateful if you could provide me with the pbix file or sample data.

When uploading a file, please be careful to delete sensitive information.

Take care to remove sensitive data.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

The following is a document on merging and appending, which I hope you will find helpful:

Merge queries overview - Power Query | Microsoft Learn

Append queries - Power Query | Microsoft Learn

If you have any other questions please feel free to contact me.

Best Regards,

Leroy Lu

[Sudhakar1000]

Hi @AllisonKennedy ,

Thank you for your solution, i have corrected all column name same then this working fine

@v-linyulu-msft  Thank you for replying - Now its working fine  

[AllisonKennedy]

So glad you got it working! Thanks for updating us 🙂