Who is online?  0 guests and 0 members
Home  »  search results

Search Results: DAX

15 results found
  • Creating a tabular database
    In SQL Server 2012 Analysis Services, Microsoft introduced the xVelocity engine and the tabular model for databases into Analysis Services. This gives much more compression and performance, but not all of the features of multi-dimensional databases are av
    Author: ChrisSchmidt ChrisSchmidt     Date: 10/23/2012     Section: Blog
  • SQL Lunch #36 - Overview of Common DAX Expressions
    Tuesday at 12:30 pm I will be presenting for SQL Lunch giving you an overview of some common DAX Expressions in PowerPivot. PowerPivot is still a very new technology and in this session you will get familiar with how you can create calculated columns and
    Author: DevinKnight DevinKnight     Date: 10/22/2010     Section: Blog
  • Implementing Common Business Calculations in DAX
    Chris Webb has spoken about "implementing common business calculations in DAX" during SQL Server Day 2010 in Belgium. Here is the link for uploaded video. Implementing Common Business Calculations in DAX DAX is Microsoft's new multidimensional calculation
    Author: sirfnet sirfnet     Date: 4/29/2011     Section: Blog
    tags : Powerpivot, SSAS
  • Sorting Month Names In DAX
    I was recently helping a client set up their PowerPivot workbook for the first time and when they brought the months over on the pivot table, the results of the month weren’t sorted. So for example, April and August were the first months the list. T
    Author: ChrisSchmidt ChrisSchmidt     Date: 10/19/2012     Section: Blog
    tags : PowerPivot
  • Getting Started With DAX in PowerPivot
    In this article you will get a quick introduction the DAX, the formula language used in PowerPivot. With this tutorial you will get a start on modifying PowerPivot data.
    Author: DevinKnight DevinKnight     Date: 10/20/2010     Section: Article
    tags : DAX, PowerPivot
  • DAX Function DAX Samples DAX Examples
    Here is list of all DAX Functions described in my posts. Please click on links to reach DAX Functions post: Time Intelligence Date and Time Statistical Filter and Value Logical CLOSINGBALANCEMONTH DATE AVERAGE ALL AND CLOSINGBALANCEQUARTER DATEVALUE AVERA
    Author: sirfnet sirfnet     Date: 4/28/2011     Section: Blog
  • Dirty looking SQL or MDX? Clean it up
    A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a website, or pulled from SQL Profiler, that is difficult to understand because it’s not formatted? Well, there are a couple of free tools that will clean up your SQL: S
    Author: jamserra jamserra     Date: 6/15/2011     Section: Blog
  • Persisting DAX queries
    This blog has moved to : http://markgstacey.net/2013/02/11/persisting-dax-queries/ In this post, I’m going to show you how to connect a tabular mode query to the cube it is sourced from – the question that I got asked by Marco Rus when I worke
    Author: MarkGStacey MarkGStacey     Date: 11/3/2012     Section: Blog
  • Notes from PowerPivot Example
    We had a bit of an impromptu session today during today's webinar. You can find the recording for that session at http://www.PragmaticWorks.com and click Webinars. Here's my scripted demo which shows DAX, PowerPivot and more from the AdventureWorksDW2008(
    Author: BrianKnight BrianKnight     Date: 5/25/2010     Section: Blog
  • PowerPivot – Commonly Used DAX Expressions
    Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used DAX Expressions. You can register (or if you miss it live watch the recording) for this webinar here . I thought it would be great if I could push ou
    Author: DevinKnight DevinKnight     Date: 8/11/2011     Section: Blog
  • Tabular Hierarchies Across Multiple Tables
    Recently I was looking at the Adventure Works database and I noticed how Product, ProductCategory, and ProductSubCategory are their own separate tables. It got me to thinking about how someone might want to take attributes from each of those tables and cr
    Author: ChrisSchmidt ChrisSchmidt     Date: 11 days ago     Section: Blog
  • PowerPivot – Creating KPIs
    Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot has made what was once a task that was done purely done by developers now something that anyone can do now. KPIs (Key Performance
    Author: DevinKnight DevinKnight     Date: 8/8/2011     Section: Blog
  • Excel and PowerPivot - an introduction
    PowerPivot, while being an Excel add-in, was built by the SQL team, and is one of the most powerful data integration tools in the Microsoft stack. In this session, you will learn how to combine data from web services, tables and cubes to build a powerful
    Author: MarkGStacey MarkGStacey     Date: 10/23/2011     Section: Blog
    tags : SQLPASS
  • PowerPivot and PowerView -- really?
    Yeah, that 32-bit Excel is what's killing your performance with PowerPivot. As far as the other stuff, I'm no PowerPivot expert but I would *think* you could cobble something together like that using DAX expressions, but I'm not the best person to ask abo
    Author: sqlchicken sqlchicken     Date: 8/17/2012     Section: Forum
  • PowerPivot and PowerView -- really?
    Jorge is absolutely right, you can do some of those "where clause" type features using DAX expressions. You would liekly want to predefine those groups in the PowerPivot data model so you can consume them in the Excel interface as filters or slicers. As f
    Author: BradSchacht BradSchacht     Date: 8/21/2012     Section: Forum
Page 1 of 1 (15 items)