Cleaner SharePoint pages, and an offer to share
“Dr. A. Heller. Weapons designer.Innovator. Inventor. World changer.” “…why does he live in a deserted amusement park?” Building an Arsenal of PowerPivot Components and Tools In the past six months […]
Tag: Power BI Workflows
Review: Prof. PowerPivot for Excel & SharePoint
No more delays! Awhile back I reviewed Mr. Excel’s PowerPivot book and vowed to post a review of the other major PowerPivot book to date, by Denny, Ron, and Siva […]
Slicers and pivot update performance
-Posted by Rob Collie OK, I was sitting at the 2nd-day keynote down in New Orleans last month, watching Amir Netz do a demo on some PowerPivot goodies we can […]
Using Excel CUBE Functions with PowerPivot
Arriving Here from a Search Engine or via Excel Help? This article below by Dick Moffat, as well as the one by Dany Hoter, is an excellent, detailed example of […]
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 […]
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 measure finished
“…I always see the job through.” -Angel Eyes Yep, I said I would return and finish off the Rank measure. Time to deliver. (And this makes three straight Spaghetti Western […]
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, […]
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 […]
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 […]
Sweden: the full videos
In case you missed them, the full videos of my presentation in Sweden were posted last week. They are long – I was on stage for over two hours combined, […]