Picture 1 of 2
Definitive Guide to DAX, The: Business intelligence with ... by Ferrari, Alberto
8M+ feedback. Millions of books, dvds & more in stock!
Condition:
6 available / 9 sold
Postage:
Located in: GB, United Kingdom
Delivery:
Varies
Returns:
Payments:
Shop with confidence
Seller information
- 98.8% positive Feedback
Registered as a business seller
Seller assumes all responsibility for this listing.
eBay item number:303409508452
Item specifics
- Condition
- Title
- Definitive Guide to DAX, The: Business intelligence with Micro...
- Book Title
- Definitive Guide to DAX, The: Business intelligence with Micro...
- ISBN
- 073569835X
- EAN
- 9780735698352
- Type
- Textbook
- Binding
- Paperback / softback
- Date of Publication
- 20151029
- Publication Name
- N/A
- Release Title
- Definitive Guide to DAX, The: Business intelligence with Micro...
- Artist
- Ferrari, Alberto
- Brand
- N/A
- Colour
- N/A
- Format
- Paperback
- Language
- English
- Publisher
- Microsoft Press,U.S.
- Subject
- Computer & IT
About this product
Product Identifiers
Publisher
Microsoft Press,U.S.
ISBN-10
073569835x
ISBN-13
9780735698352
eBay Product ID (ePID)
216579315
Product Key Features
Format
Paperback
Language
English
Subject
Computer & IT
Type
Textbook
Dimensions
Weight
958g
Height
229mm
Width
188mm
Additional Product Features
Place of Publication
Redmond
Table of Contents
Foreword xviiIntroduction xixChapter 1: What is DAX? 1Understanding the data model 1Understanding the direction of a relationship 3DAX for Excel users 5Cells versus tables 5Excel and DAX: Two functional languages 8Using iterators 8DAX requires some theory 8DAX for SQL developers 9Understanding relationship handling 9DAX is a functional language 10DAX as a programming and querying language 11Subqueries and conditions in DAX and SQL 12DAX for MDX developers 13Multidimensional vs. Tabular 13DAX as a programming and querying language 13Hierarchies 14Leaf-level calculations 15Chapter 2: Introducing DAX 17Understanding DAX calculations 17DAX data types 18DAX operators 21Understanding calculated columns and measures 22Calculated columns 22Measures 23Variables 26Handling errors in DAX expressions 26Conversion errors 26Arithmetical operations errors 27Intercepting errors 30Formatting DAX code 32Common DAX functions 35Aggregate functions 35Logical functions 37Information functions 39Mathematical functions 39Trigonometric functions 40Text functions 40Conversion functions 41Date and time functions 42Relational functions 42Chapter 3: Using basic table functions 45Introducing table functions 45EVALUATE syntax 47Using table expressions 50Understanding FILTER 51Understanding ALL, ALLEXCEPT, and ALLNOBLANKROW 54Understanding VALUES and DISTINCT 58Using VALUES as a scalar value 59Chapter 4: Understanding evaluation contexts 61Introduction to evaluation contexts 62Understanding the row context 66Testing your evaluation context understanding 67Using SUM in a calculated column 67Using columns in a measure 68Creating a row context with iterators 69Using the EARLIER function 70Understanding FILTER, ALL, and context interactions 74Working with many tables 77Row contexts and relationships 78Filter context and relationships 80Introducing VALUES 84Introducing ISFILTERED, ISCROSSFILTERED 85Evaluation contexts recap 88Creating a parameter table 89Chapter 5: Understanding CALCULATE and CALCULATETABLE 93Understanding CALCULATE 93Understanding the filter context 95Introducing CALCULATE 98CALCULATE examples 101Filtering a single column 101Filtering with complex conditions 106Using CALCULATETABLE 109Understanding context transition 111Understanding context transition with measures 114How many rows are visible after context transition? 116Understanding evaluation order of context transition 117Variables and evaluation contexts 118Understanding circular dependencies 119CALCULATE rules 122Introducing ALLSELECTED 123Understanding USERELATIONSHIP 125Chapter 6: DAX examples 129Computing ratios and percentages 129Computing cumulative totals 132Using ABC (Pareto) classification 136Computing sales per day and working day 143Computing differences in working days 150Computing static moving averages 151Chapter 7: Time intelligence calculations 155Introduction to time intelligence 155Building a Date table 156Using CALENDAR and CALENDARAUTO 157Working with multiple dates 160Handling multiple relationships to the Date table 161Handling multiple Date tables 162Introduction to time intelligence 164Using Mark as Date Table 166Aggregating and comparing over time 168Year-to-date, quarter-to-date, month-to-date 168Computing periods from prior periods 171Computing difference over previous periods 174Computing the moving annual total 175Closing balance over time 178Semi-additive measures 178OPENINGBALANCE and CLOSINGBALANCE functions 184Advanced time intelligence 188Understanding periods to date 189Understanding DATEADD 191Understanding FIRSTDATE and LASTDATE 196Understanding FIRSTNONBLANK and LASTNONBLANK 199Using drillthrough with time intelligence 200Custom calendars 200Working with weeks 201Custom year-to-date, quarter-to-date, month-to-date 204Computing over noncontiguous periods 206Custom comparison between periods 210Chapter 8: Statistical functions 213Using RANKX 213Common pitfalls using RANKX 216Using RANK.EQ 219Computing average and moving average 220Computing variance and
Pagination
592
First Published
2015
Date of Publication
13/10/2015
Genre
Computing: Professional & Programming
Country of Publication
United States
Item description from the seller
Business seller information
WORLD OF BOOKS LIMITED
Debbie Nicholl
Mulberry House
Woods Way
Goring-by-sea
West Sussex
BN12 4QY
United Kingdom
Value added tax number:
- DE 281042328
- EL 996857788
- ES N8267548I
- FR 27823676960
- GB 922696893
- IT 00185819992
Trade registration number:
- 06437594
I certify that all my selling activities will comply with all EU laws and regulations.
Seller assumes all responsibility for this listing.
eBay item number:303409508452
Postage and packaging
Item doesn't post to United States
Item location:
GB, United Kingdom
Posts to:
Belgium, Bosnia and Herzegovina, Brazil, Canada, Chile, Czech Republic, Denmark, Estonia, Finland, France, Georgia, Greece, Hong Kong, Hungary, Iceland, India, Ireland, Israel, Italy, Japan, Jordan, Kuwait, Latvia, Liechtenstein, Lithuania, Luxembourg, Malaysia, Maldives, Malta, Montenegro, Morocco, Netherlands, New Zealand, Norway, Peru, Poland, Portugal, Republic of Croatia, Rwanda, Singapore, Slovakia, Slovenia, South Korea, Spain, Sri Lanka, Sweden, Thailand, Worldwide
Excludes:
Afghanistan, Australia, Austria, Germany, Libya, Nauru, Russian Federation, Somalia, Switzerland, Ukraine, United States, Yemen
| Dispatch time |
|---|
| Will usually dispatch within 1 working day of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Sales tax for an item #303409508452
Sales tax for an item #303409508452
Seller collects sales tax/VAT for items dispatched to the following states:
| County | VAT rate |
|---|
Returns policy
| After receiving the item, cancel the purchase within | Return postage |
|---|---|
| 30 days | Buyer pays for return postage |
The buyer is responsible for return postage costs.
| Return policy details |
|---|
| Returns accepted |
Most Buy It Now purchases are protected by the Consumer Rights Directive, which allow you to cancel the purchase within seven working days from the day you receive the item. Find out more about your rights as a buyer and exceptions.
Payment details
Payment methods
Registered as a business seller
Seller Feedback (12,709,103)
This item (3)
All items (12,709,103)
n***5 (924)- Feedback left by buyer.
Past year
Verified purchase
Perfect
c***r (232)- Feedback left by buyer.
More than a year ago
Verified purchase
Book arrived promptly in excellent condition. Great service. Many thanks.
a***2 (413)- Feedback left by buyer.
More than a year ago
Verified purchase
Thanks
3***r (162)- Feedback left by buyer.
Past month
Verified purchase
Very good Ebay seller!!!!
1***r (131)- Feedback left by buyer.
Past month
Verified purchase
An interesting book with short stories, enjoyed reading this book on holiday. Delivery was prompt and book was in excellent condition.
p***o (63)- Feedback left by buyer.
Past month
Verified purchase
Good
More to explore:
- The Intelligent Investor Business, Economics & Industry Non-Fiction Hardcover Books,
- The Intelligent Investor Business, Economics & Industry Non-Fiction Hardcover Books in English,
- The Intelligent Investor Business, Economics & Industry Paperback Fiction & Non-Fiction Books,
- The Intelligent Investor Business, Economics & Industry Paperback Fiction & Non-Fiction Books in English,
- The Intelligent Investor Business, Economics & Industry Management Techniques Non-Fiction Paperback Fiction & Books,
- Study Guide School Textbooks & Study Guides,
- Chemistry Study Guide School Textbooks & Study Guides,
- Workbook School Textbooks & Study Guides,
- Spanish Travel Guide,
- English School Textbooks & Study Guides