Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  DAX
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...
    on21 Aug 2013

  • Wiki Page: DAX Resource Center

    Table of Contents You can contribute! Introduction to DAX Microsoft DAX Documentation Most Valuable Resources Samples DAX formulas in measures DAX functions Credits Welcome to the DAX Resource Center Wiki - your one stop shop for all things DAX This Wiki includes articles, whitepapers, videos...
    on13 Aug 2013

  • Wiki Page: Custom Calculations for Invoice & Returns Using a PowerPivot DAX Formula

    This is from the thread in the SQL Server PowerPivot for Excel forum. Table of Contents Problem Description Solution Step 1 Step 2 Step 3 Conclusion Problem Description Here's the sample data: STATUS WEEK SALES CUSTOMER INVOICE W01 $150...
    on6 Aug 2013

  • Wiki Page: Currency Conversion in SSAS 2012 (Multidimensional & Tabular)

    Types of Currency Conversion As defined by the Business Intelligence Wizard in Multidimensional, there are 3 types of currency conversion. One-to-many . In this case we store the transactions (for example in the data warehouse) in a single base currency. Even if they originally took place in...
    on6 Aug 2013

  • Wiki Page: Showing a 100% Progress Gauge in Power View

    by Paul Turley , Mentor, SolidQ from SQLServerBiBlog.com What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. That was easy …now that I see how to do it.” Power View sets the maximum value for a chart series based on the maximum...
    on31 Jul 2013

  • Wiki Page: DAX: Returning the Nth Selected Value in a Slicer

    by Paul Turley , Mentor, SolidQ A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that I hadn’t solved before using a tabular model and DAX. She had cost information for several hospitals in a PowerPivot model. Using an Excel pivot...
    on26 Jul 2013

  • 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...
    on25 Jun 2013

  • Wiki Page: PowerPivot: Data Analysis Expressions (DAX) Language

    Table of Contents Types of DAX Functions Overview of DAX Where to Use Formulas Creating Formulas by Using the Formula Bar Tips for Using AutoComplete Basic DAX Syntax Using Multiple Functions in a Formula DAX Data Types Formulas and the Relational Model Introduction to Context Updating the Results of...
    on13 Jun 2013

  • 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...
    on20 Apr 2013

  • Wiki Page: PowerPivot: DAX: Operator Reference

    The Data Analysis Expressions (DAX) language uses operators to create expressions that compare values, perform arithmetic calculations, or work with strings. Original article (before wiki edits) was written by Jeannine Takaki , Microsoft SQL Server Analysis Services Technical Writer. ...
    on28 Feb 2013

  • 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...
    on20 Feb 2013

  • Wiki Page: QuickStart: Learn DAX Basics in 30 Minutes

    By: Owen Duncan, MSFT This QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems...
    on10 Jan 2013

  • 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...
    on8 May 2012

  • 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...
    on4 May 2012

  • 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...
    on3 Mar 2012

  • 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...
    on24 Jan 2012

  • Wiki Page: PowerPivot: DAX: Key Concepts

    Basic DAX Syntax A DAX formula is comprised of an equal sign followed by a function or expression. Functions perform operations such as concatenating or adding values, calculating sums or averages, or performing logical tests. Functions usually take some kind of argument , which might be a reference...
    on24 Jan 2012

  • 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...
    on24 Jan 2012

  • Wiki Page: Context in DAX

    Context in DAX formulas enables you to perform dynamic analysis, in which the results of a formula can change to reflect the current row or cell selection and also any related data. Understanding context and using context effectively are critical for building high-performing, dynamic analyses, and for...
    on24 Jan 2012
Page 1 of 1 (19 items)
Can't find it? Write it!

Post an Article