Favorite Quick & Easy DAX: Calculate Moving Averages with EARLIER

Sometimes reporting data values day-by-day can create the impression of dramatic ups and downs, when really what we want to see is the general trend of changes over time.  We need, in other words, to create a chart based on moving averages.  Such a measure is commonly used in tracking the price of stocks, but there are many other cases where showing, for example, 7-day moving averages is...

Read More

Favorite Quick & Easy DAX: Lookup Values

The more I work in Power Pivot, the more I’m amazed at what can be done using DAX in Excel, Microsoft’s powerful expression language for creating custom calculations, aggregations, and references within and across data entities. In this post, I take a look at the very useful LOOKUP VALUE expression, for when you want to scan any table in your data model, find a specific value, and relate that...

Read More

Favorite Quick & Easy DAX: Calculate Percent of Total Scenario

One of the greatest benefits of creating a PowerPivot or tabular model is the ability to easily build custom calculations, using Data Analysis Expressions (DAX). With DAX, you can create custom calculations using mathematical and other functions, inserted in a new column. DAX supports most of the formulas familiar to Excel users (such as SUM, COUNT, AVERAGE), but also enables look ups and...

Read More
Phone: 312-602-4000
Email: marketing@westmonroepartners.com
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons