How to use 2 excel sheets that contain the same headings?

[jjattwood]

Hi All,

I have an excel database with a number of headers such as Name, Date of Receipt, Total Fee, Country, Sector etc

I have setup everything using this excel sheet and it works fine. Now I'd like to add another sheet which has the same headers but different values for each.

What's the easiest way to combine the data so that it reads the values from both sheets as they're updated? I can't add 2 different measures or filters to certain cards or graphs.

New to PowerBI so would appreciate a clear explanation!

Thanks!

[aj1973 · Accepted solution]

Hi @jjattwood 

Open Power query and append the 2 sheets

[jjattwood]

Thanks for the quick response Amine

[aj1973]

Welcome