DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Back to Part 1 Download this workbook Here The Formula for the Slope of a Linear Regression Line.  It’s Greek to Me.(Get it?  Gree

Zoe Helps Me Answer a Long-Simmering Question This summer we welcomed Zoe Stein (an Industrial Engineering major from Georgia Tech) to the team for a summe

Scenario A retail firm believes that its sales are driven by an external index that we will call the "Real Wage Index". This index tracks real hourly wages adjusted for inflation, seasonality, etc. The retail firm believes that this index is a 3-month leading indicator, meaning that when the index g...

Out of 407 Total Combinations of Subcategory and Region, These 8 Stand Out This Month (These 8 Combinations Differed GREATLY from their Respective 12-month

Power BI and R – Part 1 (Intro) http://blog.janmulkens.be/power-bi-and-r-part-1-intro/

Use R to export data from Power BI (and Power Query) http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/