Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
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
Date: 10/23/2012 Section:
Blog
tags :
2012
,
Analysis Services
,
BI
,
BISM
,
Business Intelligence
,
DAX
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
Date: 10/22/2010 Section:
Blog
tags :
DAX
,
PowerPivot
,
SQL Lunch
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
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
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
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
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
Date: 6/15/2011 Section:
Blog
tags :
quick tip
,
SQL Server
,
MDX
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
Date: 11/3/2012 Section:
Blog
tags :
DAX Analysis Services Tabular PowerPivot SSAS Persist View
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
Date: 5/25/2010 Section:
Blog
tags :
PowerPivot
,
SQL Server 2008 R2
,
Power Pivot
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
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
Date: 11 days ago Section:
Blog
tags :
dax hierarchies across multiple tables
,
Tabular hierarchies
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
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
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
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
Date: 8/21/2012 Section:
Forum
Page 1 of 1 (15 items)