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, […]
Category: Self-Service Data Tools
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 […]
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 […]
Power BI and Power Pivot DAX: CALCULATE is a supercharged SUMIF
“No [doubt] she’ll freak. I’m just contemplating the =IF()’s…” -Marcellus Wallace, obvious master of the spreadsheet arts CALCULATE is a supercharged SUMIF I can’t believe I didn’t say this last […]
DAX’s CALCULATE() function – if you’re not using this in Power BI (or Excel), it’s time to start
When I last worked on the football project, I had designed my first report and started the process of better understanding my source data, primarily using the =RELATED() function.
Introducing PowerPivot DAX Measures
Up until this point, I’ve just used DAX (PowerPivot’s extension to the Excel formula language) to create calculated columns in the PowerPivot window. There’s a lot of utility in DAX […]
What is Power Pivot?
So what is Power Pivot? I think a lot of people arriving at this site for the first time already know quite a bit about what Power Pivot is, but […]