Power BI

The Handling Different Granularities pattern is a technique to show and hide measures depending on the level of granularity of the underlying data. For example, you do not want to display a measure

Introduction By now you have likely heard a little about Power Query (formally known as Data Explorer).

The Parameter Table pattern is useful when you want to add a slicer to a PivotTable and make it modify the result of some calculation, injecting parameters into DAX expressions. To use it, you must

Football data source tables - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2009/10/football-data-source-tables/

SQLBI - Marco Russo : How CALCULATE works in DAX via Instapaper http://sqlblog.com/blogs/marco_russo/archive/2010/01/03/how-calculate-works-in-dax.aspx

Dynamic Charting In Power Pivot - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2014/08/dynamic-charting-in-power-pivot/

Writing a RANK measure (and living to tell the tale) - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/03/writing-a-rank-measure-and-living-to-tell-the-tale/

ALL() Revisited - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/02/all-revisited/

Resolving Many to Many relationships leveraging DAX Cross Table Filtering via Instapaper https://gbrueckl.wordpress.com/2012/05/08/resolving-many-to-many-relationships-leveraging-dax-cross-table-filtering/

Use slicer values in a calculation with PowerPivot DAX - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/06/use-slicer-values-in-a-calculation-with-powerpivot-dax/

It’s Actually VERY Simple to Catch Users’ Slicer Selections in Excel Formulas,IF You Are Using PowerPivot (AKA the 2013 Data Model Feature) A Popula

Another one from the Mr. XL Forum!

Yes, That IS a Measure Third and Final Mini-Post for Today Got a question from a friend yesterday that made me realize I should share this:  in

Guest post by David Churchward Using Time Intelligence in PowerPivot can appear scary when you first start using it and I

“Wait a minute. There might be legal precedent. Of course. Land snatching. Let's see, land, la-land...see snatch. snatch...snatch...ah! Haley vs. United st

“I'm Dan Marino, and IF() anyone knows the VALUE() of protection, it's me.” Boom!  An Ace Ventura quote finally graces the blog.  Yes folk

A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function.  Ti

Greetings from Israel!

Two mini-posts today:  this one and then an updated ROI Quadrant. This one falls under the “quick tip” category (and the “MacGyver” category we

The Pivot On the Left is Correct and the Pivot on the Right is Not.But the Formulas Are the Same in BOTH Pivots! A Semi-Common Question From time to

Got this question yesterday from the DJ Monkey

Measure Matches at the Shape Level (Orange Cells) But Matches Down at the Color Level Quick Post Today I’m halfway on vacation today in Florida, vis

By Avichal Singh [Twitter] Dynamic segmentation or banding has been covered in PowerPivotPro articles in the past and in beautiful detail by the Italians

Post by Rob Collie Did Someone Say Deliberately

Post by Rob Collie In 2004, There Were 2,561 Customers Who Bought Something in the Southwest.But How Many of Those Were Repeat Customers?

Is this possible? Someone at Microsoft asked me this question the other day:

Guess Post by Scott Senkeresty Intro Rob is taking a much-needed vacation this week, so you get to hang out with me again.