As promised, here is the workbook that contains everything I have demonstrated so far in the Temperature Mashup example.
Click here to download workbook
(NOTE: I discovered a bug in the original file – the Qty per Day measure was returning incorrect results. The version above is now is fixed. Also no longer needs to be renamed from .DOCX).
And the updated demo walkthrus for this workbook are here:
Joining the temperature data to my sales data
Creating a Sales Qty Per Day Measure
[...] Leave a Comment Tags: Excel, Workbook Don’t forget to download Rob Collie’s Temperature Mashup Demo at PowerPivotPro.com. The workbook provides a great example of how to join two different sets of [...]
Hi,
The link to temperature-mashup-bug-fixed.docx opens Word (2010), but it’s empty and there’s nothing to save!
Please read the notes. WordPress doesn’t let me upload XLSX files or even ZIP files. You must save that file and then rename it to XLSX. Sorry.
OK, I’ve uploaded the XLSX to a SkyDrive. Link fixed. No more need for rename. My apologies for the confusion Matt
(And thanks to Vidas for the suggestion)