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
Category: Power BI
Power BI Jun 2nd Webinar Recording Available
Thanks to all, who attended our Power BI Webinar on Jun 2nd. We had 400+ (well, 438 to be precise) attend, what ended up being a 2 hour webinar with all the questions being asked.
A New Take on “Data Quality?”
Bad Data DOES Lead to Bad Results. But Good Data Can STILL Lead to Bad Results. Garbage in, Garbage out. We’re all familiar with this. If you’re being given junky source data, it’s going to be hard to perform ANY meaningful analysis or reporting on said data until the quality of the inputs is addressed.
Some Good Power Pivot / Power BI Computers
Last month I posted a survey of computer performance for Power Pivot and Power BI usage.
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.
Free Webinar: How to Build BI Solution Using Power BI
Rob made a joke in one of his classes, that “Microsoft gives you the parts to the Porsche”.
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 .
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.