Using SELECTEDVALUES To Capture Power BI Slicer Selections
Hello P3 Adaptive Nation, I’m excited to be back and writing a technical post again…it’s been too LONG!
Category: Quick Tips & Tricks
Power Query (M)agic: Consecutive Days (Part 2)
Two weeks ago I wrote a blog post about how to create a set of data with Consecutive Days using SQL or Power Query.
Chatting with John Michaloudis & Rob Collie
The #1 Supporter of our 2nd Edition Book Sits Down for a Virtual Interview
DAX Reanimator Series – Part 3: Compare Product Performance After Launch
Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.
Power Query (M)agic Part 2: Organizing Your Queries
Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.
So Your Detailed/Flat Pivot is Slow and Doesn’t Sort Properly? Try Text Measures!
Yes, you know that pivots are meant to show aggregations. Summaries.
DAX – The Diabolical Genius of “SWITCH TRUE”
SWITCH() is still testing for equivalence! By providing the first argument as TRUE(), now each subsequent “test” will check for TRUE().
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 – SUMX of IF: A Perfect Blend of Simple & Sophisticated
In This Case, Getting the Grand Total Correct for Each Row Required SUMX It’s that time of year again… …when my love of spreadsheets actually translates into a love of […]
DAX – The Many Faces of VALUES()
aybe it is a sign of where I am on the Geek Scale compared to Rob, but where he considers EARLIER() to be a pretty hard function to understand, it just doesn’t bother me. At least it seems to have just one purpose in life.
DAX – “CONTAINSX” Revisited: What WAS the Match?
Last week’s post on “CONTAINSX” proved to be quite popular. In the comments, Sasha provided an alternate formula that used FILTER instead of SUMX
DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2
These are a few of my favorite things… Perhaps the only thing that makes me happier than a new “X” function (I still badly want a CONCATENATEX) is “inventing” a new one (like we’ve seen with PRODUCTX).