Microsoft Excel 2013: Building Data Models with PowerPivot

Companion content

Insert your email address and press Download for access to the files used in this book.

9780735676343.zip(227.8MB)

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

Corrections in this section are important to fully understand the concepts explained in the book.

No important issues have been reported yet.

Minor issues

Corrections in this section do not affect the ability to learn the concepts explained in the book.

Page 406: Inequality operator in sample code

The code has a inequality operator (<>) instead of greater than (>) at line 11:

BoughtProduct :=
CALCULATE (
    COUNTROWS ( DimCustomer ),
    CALCULATETABLE (
        FILTER (
            DimCustomer,
            AND (
                CALCULATE (
                    COUNTROWS ( FactInternetSales ),
                    USERELATIONSHIP ( FactInternetSales[ProductKey], ProductBought[ProductKey] )
                ) <> 0,
                CALCULATE (
                    COUNTROWS ( FactInternetSales ),
                    USERELATIONSHIP ( FactInternetSales[ProductKey], ProductToCheck[ProductKey] )
                )
            ) = 0
        )
    ),
    FILTER (
        ALL ( DimDate ),
        DimDate[FullDateAlternateKey] < MAX ( DimDate[FullDateAlternateKey] )
    )
)

Nov 16, 2018