Rediscovering (fire)matting: a truly amazing BI “tool”
This automatic BI tool has saved me innumerable hours each month and I find this useful for at least 80% of my DAX formulas.
Category: Skill Areas
Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to update… A while back, I was tasked with finding a way to automate […]
Nested SUMX or DAX Query?
I was helping a friend out recently with an interesting problem. It all started with a SUM( ) that wasn’t behaving.
Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine
Intro from Rob: Today I’m interviewing Chris Finlan of Microsoft about MS’s recent acquisition of Datazen, and what this means to us in the Power Pivot and Power BI community.
DAX – Dynamic Age Calculation Using Measures
I was recently helping a forum member at https://powerpivotforum.com.au with a problem about how to dynamically calculate an employee’s age.
Displaying Top N, Bottom N, and “All Others”
If We Use Excel’s Built-In Top N Filter to See Our Top 1,000 Customers, It Hides the Other Customers Completely. But Using DAX, We Can Just “Split” the Audience into Two Groups.
DAX – Week Ending Date Calculation
The first thought to occur to me was “well, for each Year&WeekOfYear, I just want to grab the max date”. That sounded easy enough… EARLIER() no longer scares me
Grand Total Mania! (Totals at Top & Multiple Totals)
Let’s start 2014 with a bang… I’ve been dying to write this post for awhile now. Let’s say you want your grand totals to appear at the top of your […]
A Simple Measure for Projections with Act! CRM
Continuing the series of guest posts that got temporarily shelved, today we have one from Vivek Gargav.
PowerPivot vs. Power View: What’s the Difference?
’ve been getting this question a lot lately: How does Power View relate to PowerPivot? Is PV a replacement for PP?
Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros
Excel 2013 public preview (aka beta) is out, which means that now we’re not only playing around with PowerPivot V2 and Power View V1, but now we have another new set of toys to take for a spin.
Dynamic TopN Reports via Slicers, Part 4 – The Dot Plot PivotChart
After completing the Part 3 extension of Rob’s Dynamic TopN Reports via Slicers, Part 2 post, I did not plan on a forth installment.