Use slicer values in a calculation with PowerPivot DAX
By Kasper de Jonge, crosspost from PowerPivotblog.nl A while ago i had a question on my ask a question page, Sasha wanted to do the following: How to define the date […]
Content Type: Blog Post
Welcome Query designers!
-Guest Post by the one and only Dany Hoter! We Excel geeks aren’t spoiled with fancy query builders. We have had MSQuery for the last what? 15 years? Suffice to […]
Calling a Stored procedure in PowerPivot
By Kasper de Jonge, crosspost from PowerPivotblog.nl While building a new PowerPivot workbook i wanted to use Time Intelligent functions. One of the golden rules of PowerPivot time intelligent functions is […]
PowerPivot time intelligent functions: why use ALL() and how to work around it
Posted by: Kasper de Jonge Last week I got a most excellent question from Sasha at my question page. Using my time intelligent function screencast Sasha created a workbook using […]
Quick Tip: Don’t Over-Use DAX FILTER() function in Power BI
The other day I was working on an updated version of my Team Playcalling report, which, by the way, look FABULOUS with Slicers: Only problem with it was that it […]
Rank continued – dealing with unknown members
TUCO: “There’s no name on it!” BLONDIE: “Well, there’s no name here, either.” Ode to YouTube HD When I used to work on Bing and would look at search logs, […]
Guest Post: Dany Hoter on Cube Formulas
“OK, I want the brooding frontman in the foreground, and the keyboard player and drum machine programmer in the back.” -Photographer for the EuroSynth band, MDX I’ve always loved this […]
DAX ALL() Revisited
“He has no filter. He says whatever comes through his mind. He never edits himself.” Revisiting ALL() Yes, I’ve used ALL() a number of times already. But I’ve never covered […]
Generating a Tag Cloud via PowerPivot
“Navajos say it is good plan to have two arrows for one bow” – Chief Thundercloud Thanks to Rob Collie for letting me do another guest post. There will be […]
The Superheroes of DAX, and derived measures
“Did someone say DAX?” I wanted to start today’s post with a quick thank-you to the guys who tirelessly answer my DAX questions. Marius Dumitru, Howie Dickerman, and Karen Aleksanyan. […]
DAX SUMX() – Power BI’s 5-point palm, exploding fxn technique
“AGAIN!” -Pai Mei SUMX() – the great iterator Have you ever written an array formula in Excel? (Don’t worry, most people haven’t). Have you ever written a FOR loop in […]
DAX: I’ve been shortchanging you
Mmmm! Daaaamn, Jimmie! This is some serious gourmet DAX! Usually, me and Vince would be happy with some freeze-dried Taster’s Choice right, but he springs this serious GOURMET DAX on […]