Power Query (M)agic: Consecutive Days
Hello P3 Adaptive World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 2017!
Tag: Educational Content
Dynamic Attributes In A Power BI Report
Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.
SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!
I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
One of my colleagues and I have been geeking out the last few years over all things Power (Query, Pivot, View, and now BI).
DAX Reanimator Series: Top Performers using SUMMARIZE
Welcome back P3 Adaptive nation, today I’d like to demonstrate some exciting ways to show Top Performing “things” using DAX. Most of what we’ll discuss has been covered before in […]
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.
Rediscovering (fire)matting: a truly amazing BI “tool”
This automatic BI tool has saved me innumerable hours each month and I find this useful for at least 80% of my DAX formulas.
The Ten Pitfalls of the Data Wrangler (aka the Wielder of M/Power Query)
Ten Pitfalls of the wrangling of using Power Query and how to avoid them, written by P3 Adaptive , Rob Collie.
Sort Your Data on Load for Improved Compression
My last 2 blog posts have been about data compression – that theme continues today. In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.
Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot.