Browse by Tags

Tagged Content List
  • Wiki Page: PowerPivot Measures

    This article shows you how to create a measure based on data in the Data Analysis Expressions (DAX) sample workbook. The workbook includes bike-related data from the AdventureWorks database. For information about where to get the sample workbook, see Get Sample Data for PowerPivot in the TechNet Library...
  • Wiki Page: PowerPivot Glossary

    Microsoft SQL Server PowerPivot provides features that span many technology areas, from relational databases, to analytics, to Web publishing. This article provides definitions for some PowerPivot terms and provides links to related content in the TechNet Library. Add words and tweak the definitions...
  • Wiki Page: Microsoft SQL Server 2008 SP2 Release Notes

    Click here to change the language . These release notes are carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. Because this is a wiki, additions or refinements to these release notes might have been made by community members...
  • Wiki Page: PowerPivot: DAX: Text Functions

    Data Analysis Expressions (DAX) includes a set of text functions that is based on the library of string functions in Excel, but it has been modified to work with tables and columns. Read more about the following text functions: BLANK CONCATENATE EXACT FIND FIXED FORMAT LEFT...
  • Wiki Page: PowerPivot: DAX: Filter Functions

    The filter and value functions in Data Analysis Expressions (DAX) are some of the most complex and powerful, and differ greatly from Excel functions. The lookup functions work by using tables and relationships, like a database. The filtering functions let you manipulate data context to create dynamic...
  • Wiki Page: PowerPivot: DAX: Logical Functions

    Logical Data Analysis Expressions (DAX) functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results. Read more about the following logical functions...
  • Wiki Page: Microsoft SQL Server 2008 SP2 Release Notes Language Options

    Select a language for Microsoft SQL Server 2008 SP2 Release Notes: English Chinese - Simplified (zh-CN) Chinese - Traditional (zh-TW) French (fr-FR) German (de-DE) Italian (it-IT) Japanese (ja-JP) Korean (ko-KR) Portuguese (pt-BR) Russian (ru-RU) Spanish (es-ES)
  • Wiki Page: PowerPivot: DAX: Statistical Functions

    Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel. Read more about the following statistical functions: AVERAGE AVERAGEA AVERAGEX COUNT...
  • Wiki Page: PowerPivot: DAX: Date and Time Functions

    The Date and Time Functions in Data Analysis Expressions (DAX) are similar to date and time functions in Microsoft Excel. However, DAX functions are based on the datetime data types used by Microsoft SQL Server. DAX also includes a set of time intelligence functions that enable you to manipulate data...
  • Wiki Page: Notas de Versão do Microsoft SQL Server 2008 SP3 (pt-BR)

    Clique aqui para alterar o idioma . Estas notas de versão são monitoradas com rigor e cuidado. As alterações feitas por você serão avaliadas e aceitas, refinadas ou revertidas rapidamente. Como se trata de um wiki, as adições ou melhorias a estas...
  • Wiki Page: PowerPivot: DAX: Time Intelligence Functions

    Data Analysis Expressions (DAX) includes time intelligence functions to support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods. (For community resources...
  • Wiki Page: PowerPivot: DAX: Math and Trigonometric Functions

    The mathematical functions in Data Analysis Expressions (DAX) are very similar to the Excel mathematical and trigonometric functions. Read about the following math and trigonometric functions: ABS CEILING EXP FACT FLOOR INT ISO.CEILING LN LOG LOG10 MROUND PI...
  • Wiki Page: PowerPivot: DAX: Information Functions

    A Data Analysis Expressions (DAX) information function looks at the cell or row that is provided as an argument and tells you whether the value matches the expected type. For example, the ISERROR function returns TRUE if the value that you reference contains an error. Read more about the following...
Page 1 of 1 (13 items)
Can't find it? Write it!