Power Query (M)agic – Nested Calculations in Power Query – Finance Application
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell.
Category: Excel 2013
Why Excel’s Power Query Refresh Speeds Suck
Ever noticed that Power Query refresh is slower in Excel than Power BI? Ken Puls, PQ Expert, explains the problem and what you can do to fix it!
PowerPivot vs. Power View: What’s the Difference?
’ve been getting this question a lot lately: How does Power View relate to PowerPivot? Is PV a replacement for PP?
Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros
Excel 2013 public preview (aka beta) is out, which means that now we’re not only playing around with PowerPivot V2 and Power View V1, but now we have another new set of toys to take for a spin.
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 […]