PowerPivot – DAX Formulas – SOLD!

One of the features in PivotTables we always wanted was the ability to throw in a measure in the middle of it.   You really couldn’t do that unless you converted it to cube functions, but then you lost some of the drag and drop features.

I’m watching a LiveMeeting on DAX formulas.   Coming in PowerPivot are these great DAX features that allow me to create measures on the fly.  Now I can create a measure of relating tables and boom!   Deploy it.   Great feature.

 

Here are a few simple DAX formulas to show how these look a lot like Excel formulas.

DAX formula

Comment

= [First Name] & “ “ & [Last Name]

concatenation of strings is just like in Excel

=SUM(Sales[Amount])

SUM function takes a column instead of a range of cells

=RELATED (Product[Cost])

new RELATED function follows relationship between tables

More info can be found here: http://blogs.msdn.com/powerpivot/archive/2009/10/01/introduction-to-data-analysis-expressions-dax-in-gemini.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s