I came across a great blog post that shows how to import two excel sheets that have a similar column structure into one PowerPivot Table:
http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/
Very nice!
All about Power BI, Modelling, DAX and Microsoft BI
I came across a great blog post that shows how to import two excel sheets that have a similar column structure into one PowerPivot Table:
http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/
Very nice!
This is a wonderful/useful post. Thanks for sharing.