Great progress, well done.
First step - mark table "qryDates" as the Date Table (PowerPivot editor: Select table "qryDates", select Design > Calendars > Mark as Date Table > Mark as Date Table).
Now create some measures:
And just for fun:
Format measures to suit (e.g. Currency, %) and add to your report as required.
A couple of good practice footnotes:
1. Resist the urge to prefix tables and queries, such as tblSales and qryDates. These tables become consumer facing in your data model - use real world sensible names (so, just "Sales" and "Dates" would work fine).
2. Get into the habit of creating explicit measures for everything you want to see as a value in a report, rather than using implicit aggregations of columns. This enable referencing / re-use of all your measures, and can make your model much simpler for consumers.
See attached for example.
Bookmarks