Optimizing DAX, Second Edition

Errata corrige

To ensure the ongoing accuracy of this book and its companion content, we have reviewed and confirmed the errors listed below. If you find a new oversight not included in both of the following sections, please report it to us.

Important issues

No important issues have been reported yet.

Minor issues

• Page 16: Replace “Year Month” with “Month”

  In the last paragraph, replace “Year Month” with “Month”.
  The sentence “Even though the query groups by Date[Year], Date[Year Month] (and Date[Year Month Number] because of the sort-by-column property), …” should be “Even though the query groups by Date[Year], Date[Month] (and Date[Month Number] because of the sort-by-column property), …”

  May 20, 2024
• Page 25: Missing “be” in third paragraph

  The last sentence in the third paragraph should be “even though in smaller models the difference might not be measurable” – the sentence in the book is missing the “be” verb.

  May 15, 2024
• Page 43: Replace Brand with Category

  In the first line of the last paragraph, replace Product[Brand] with Product[Category]. The first sentence should be “Solving the query requires a scan of Sales with a filter on Product[Category]“.

  Apr 30, 2024
• Page 92: Invert latter and former query

  In the last line of the page, the sentence “by the latter query and not by the former” should be “by the former query and not by the latter”.

  Aug 2, 2024
• Page 325: Misplaced field name

  In the last paragraph, replace “retrieve the list of all product names,” with “retrieve the list of all currency codes,”

  Aug 5, 2024
• Page 429: Replace “female” with “male”

  In the second line of the third paragraph, replace “female” with “male”. The correct sentence is “and the second filters male customers only”.

  Sep 29, 2024
• Page 465: Missing “engine” word

  In the last paragraph, the “engine” word is missing in this sentence: “and the way the engine performs the worst”

  Jul 6, 2024
• Page 466: Replace “month” with “year”

  In the second paragraph, the “month” reference should be replaced by “year”, and “year-month” should be replaced by “year”.
  The statements should read: “Tabular must compute the sales amount by customer and year in a datacache. Next, it iterates over the customer and year columns to aggregate the results and produce its output.”

  Jul 6, 2024
• Page 467: Replace “year-month” with “year”

  In the first paragraph, the “year-month” reference should be replaced by “year”.
  The statements should read: “the first xmSQL query retrieves the sales amount by year and customer”

  Jul 6, 2024