Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot.
Category: DAX
Break your DAX Problem into Manageable Parts
One of the concepts I discuss in my new book Learn to Write DAX, is that you should break your DAX problems into manageable pieces so that you can solve the problem one step at a time.
Complex Customer Cohort Retention Using PRODUCTX
Post by Rob Collie First, a Few Quick Updates…
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.
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 – RANKX with Ascending Order to Show Lowest Quotes by Vendors
This post is based on a query that I got in our monthly Q&A session held for our Online Class attendees.
Cycle Plots Show You Data Insights using Power Pivot and Power BI
By Avi Singh [Twitter] If you want to look for trends based on weekday (Sunday…Saturday) or month-of-the-year seasonality (January…December), Cycle Plots can be a potent visualization tool.
RANKX-apalooza: Within and Across Groups, With Filters, Etc.
One from the Reference Stacks I sometimes find RANKX() a bit perplexing. So awhile back I made myself a workbook of
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().
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 – SUM, SUMX or CALCULATE()…Choices, choices!
When I was working recently with a client, helping her remotely – I asked her to calculate the sum for sales amount in the table. She responded whether she should use SUM, SUMX or CALCULATE?