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.
Category: Self-Service Data Tools
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.
Power BI Desktop (Designer) vs. Excel: Rematch
In our last webinar the #1 question and confusion seemed to be around Excel versus Power BI Desktop (formerly called Power BI Designer). The thing is, both tools are really part of an ecosystem. And the biggest confusion was around understanding how these tools fit into the overall landscape.
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.
Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
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
Power Query Super Charges the Internet
I spent time recently thinking about how Power Query has really opened up the data on the Internet and made it more accessible to us all.
Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine
Intro from Rob: Today I’m interviewing Chris Finlan of Microsoft about MS’s recent acquisition of Datazen, and what this means to us in the Power Pivot and Power BI community.
Harness Power Query to Gain Competitive Analysis Insights from LinkedIn
Guest Post by Gil Raviv Intro: Many experts had proclaimed LongForm Journalism was headed towards extinction in the digital age. In fact it has found a new resurgence and a […]
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().
Introducing Power Update!
An article on the introduction to Power Update by the experts at P3 Adaptive .