Transcription
Data Analysis Expressions (DAX)ReferenceSQL Server 2012 Books OnlineSummary: The Data Analysis Expressions (DAX) language is a library of functions andoperators that can be combined to build formulas and expressions.Category: ReferenceApplies to: SQL Server 2012Source: SQL Server Books Online (link to source content)E-book publication date: June 2012
Copyright 2012 by Microsoft CorporationAll rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any meanswithout the written permission of the publisher.Microsoft and the trademarks listed lectualProperty/Trademarks/EN-US.aspx are trademarks of theMicrosoft group of companies. All other marks are property of their respective owners.The example companies, organizations, products, domain names, email addresses, logos, people, places, and eventsdepicted herein are fictitious. No association with any real company, organization, product, domain name, email address,logo, person, place, or event is intended or should be inferred.This book expresses the author’s views and opinions. The information contained in this book is provided without anyexpress, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors willbe held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
ContentsData Analysis Expressions (DAX) Reference . 8DAX Syntax Specification for PowerPivot . 8DAX Operator Reference for PowerPivot . 15Parameter-Naming Conventions . 20Understanding Functions for Parent-Child Hierarchies in DAX. 22DAX Function Reference. 27DAX Queries . 27DAX Query Syntax Reference. 28Parameters for DAX Queries . 29Date and Time Functions . 30Time Intelligence Functions. 31CLOSINGBALANCEMONTH Function. 32CLOSINGBALANCEQUARTER Function . 34CLOSINGBALANCEYEAR Function. 35DATEADD Function . 37DATESBETWEEN Function . 38DATESINPERIOD Function. 40DATESMTD Function . 41DATESQTD Function. 42DATESYTD Function. 44ENDOFMONTH Function . 45ENDOFQUARTER Function. 46ENDOFYEAR Function . 47FIRSTDATE Function . 49FIRSTNONBLANK Function . 50LASTDATE Function . 51LASTNONBLANK Function . 53NEXTDAY Function. 54NEXTMONTH Function. 55NEXTQUARTER Function. 56NEXTYEAR Function. 58OPENINGBALANCEMONTH Function. 59OPENINGBALANCEQUARTER Function. 61OPENINGBALANCEYEAR Function. 62PARALLELPERIOD Function. 64PREVIOUSDAY Function. 66PREVIOUSMONTH Function. 67PREVIOUSQUARTER Function. 69
PREVIOUSYEAR Function . 70SAMEPERIODLASTYEAR Function . 71STARTOFMONTH Function . 73STARTOFQUARTER Function. 74STARTOFYEAR Function . 75TOTALMTD Function . 76TOTALQTD Function. 78TOTALYTD Function. 79DATE Function . 81DATEVALUE Function. 85DAY Function . 86EDATE Function . 87EOMONTH Function. 89HOUR Function . 90MINUTE Function . 91MONTH Function . 92NOW Function . 94SECOND Function . 94TIME Function . 96TIMEVALUE Function. 98TODAY Function . 99WEEKDAY Function. 99WEEKNUM Function. 101YEAR Function . 103YEARFRAC Function. 104Filter Functions . 106ALL Function. 107ALLEXCEPT Function. 112ALLNOBLANKROW Function. 114ALLSELECTED Function. 118CALCULATE Function . 126CALCULATETABLE Function. 128DISTINCT Function . 129EARLIER Function. 131EARLIEST Function . 134FILTER Function . 135FILTERS Function. 137HASONEFILTER Function . 138HASONEVALUE Function. 139ISCROSSFILTERED Function . 141ISFILTERED Function . 145KEEPFILTERS Function. 148RELATED Function .
Title: Data Analysis Expressions (DAX).pdf Created Date: 6/26/2012 7:16:12 PM
