Appendix A: Answers to Practic Exercises

A dedicated forum to help people when working through the book "Learn to Write DAX"
Jen
Posts: 6
Joined: Tue Feb 16, 2016 8:23 am

Appendix A: Answers to Practic Exercises

Postby Jen » Tue Feb 16, 2016 10:09 am

Assuming I am working off the correct version of the Access database (Matt sent me a link to the file in Dropbox), there are naming inconsistencies between the Access database and the answers, as well as inconsistencies within the book itself.

Appendix A: Answers... (pg 175)
A. SUM()
#3. Answer refers to Total Sales Value. The exercise on pg 36 has you creating "Total Sales Amount"
#4. Answer refers to Total Sales Value. The exercise on pg 36 has you creating "Total Sales Amount"
#5. Answer refers to ...SUM(Sales[SalesTax]). My Access file has Sales[TaxAmt]
#6. Answer refers to ...[Total Sales Value] + [Total Sales Tax]. The exercise on pg 36 has you creating "[Total Sales Amount]" and "[Total Sales Tax Paid]"

I'm using a printed copy of the book.

Jen
Posts: 6
Joined: Tue Feb 16, 2016 8:23 am

Re: Appendix A: Answers to Practic Exercises

Postby Jen » Tue Feb 16, 2016 1:35 pm


MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Appendix A: Answers to Practic Exercises

Postby MattAllington » Wed Mar 02, 2016 6:57 am

Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Appendix A: Answers to Practic Exercises

Postby MattAllington » Wed Mar 02, 2016 7:02 am

Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

PaulInSydney
Posts: 7
Joined: Sat Dec 10, 2016 2:43 pm

Re: Appendix A: Answers to Practic Exercises

Postby PaulInSydney » Thu Jan 05, 2017 11:33 am

Jen,

Thanks for posting this, I was also getting caught out on the different names in Appendix A. Especially the TaxAmt one.

Regards,
Paul.


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest