#PowerPivot
LightNews LightNews
jimhenleymusic.bsky.social
Someone really hates PowerPivot
YouTube thumbnail titled :The WEIRD Adventures of DAX THE DAMNED
November 5, 2026 at 3:58 AM
skillwave.training
Stop trying to figure it all out on your own - we've got you covered! 👊 Join Skillwave today and unlock the full potential of #PowerBI, #PowerQuery, #PowerPivot, and #Excel.
Our #DataAnalytics and #BusinessIntelligence courses are designed by leading experts. 💻 View catalog at skw-t.com/courses
Struggling with learning on your own? (Image of a woman sitting in front of a laptop with her head in her hands and despondent look on her face.) (Skillwave Training logo)
November 4, 2026 at 5:10 PM
excelguru.ca
Day 2 of my live #SelfServiceBI Boot Camp in Bulgaria focused on #PowerPivot and #DataModeling. One of the key takeaways is that Facts and Dimensions should always live in separate tables.
Fact = something that can be aggregated! 🧮
Dimension = how we slice our facts! 🔪

#BusinessIntelligence #Excel
Picture of Ken's set-up for teaching at Bulgaria Excel Days 2026, including laptop, tablet, and handout folders for students. What is a Fact? Something that is aggregated - Could be values or text! Examples - Sum of Amount - Count of Customers Easy to identify - Live in the bottom right corner of the Pivot! (Screenshot of the available PivotTable fields with the Value section at the bottom right highlighted in orange with "It's a Fact!") (copyright Excelguru Consulting Inc.) What is a Dimension? How we slice our Facts Examples - Account Group - Customer Class - Year, Month, Day Easy to identify - Row, Column or Filter Fields (not Values) - Slicers or Timelines If it won’t be aggregated, then it’s a Dimension (Screenshot of the available PivotTable fields with all of the the Dimension fields highlighted in blue, and the Fact field highlighted in orange with "It's a Fact!") (copyright Excelguru Consulting Inc.)
October 21, 2026 at 8:05 PM
skillwave.training
🕒Time intelligence is the collective name for patterns that can be used to solve time comparison problems, such as current VS previous month's sales. 📈 If you do time-based comparisons using #DAX, #Excel #PowerPivot, and/or #PowerBI, this article is for you: exceleratorbi.com.au/dax-time-int...
Screenshot of a PivotTable showing the Total Sales, Sales Prior Year, Change vs Prior Year, and % Change vs Prior Year for each of the 12 months of the selected year. Formatting has also been applied to help highlight increases vs decreases for each month.
October 12, 2026 at 5:30 PM
excelguru.ca
A question sent in for our recent 'Ask Ken Anything' (AKA) session tackled a common reporting headache: how do you compare hours logged in a project management system against data from time-tracking software? 🕒
I walked through a solution I built using #PowerQuery and #PowerPivot. 🧵
Turning Durations Into Hours: A student asked how to compare hours logged in a project management system against data from time-tracking software. Ken Puls’ solution used Power Query to clean and transform the data from both sources into a common data type, which could then be more easily compared! (Screenshot of the Power Query Editor displaying the initial time tracker data in the Screen Time columns as miniscule decimals. The Transform > Duration > Total Hours options from the ribbon are highlighted, which then displays the converted values in Screen Time column.) (Skillwave Training logo)
October 12, 2026 at 5:12 PM
skillwave.training
Here, @excelguru.ca explains the types of blanks that can show up in #PivotTables built from the #DataModel. 🙃 If you work with #Excel PivotTables, #PowerPivot, #DAX, or #PowerQuery, this will help you understand where blanks come from and how to deal with them: www.youtube.com/watch?v=fnVU...
Why PivotTables Show Blanks — and How to Fix Them
In this video, Ken explains the different types of blanks that can show up in PivotTables built from the Data Model. You’ll see why measure calculations can return blanks when no rows remain after…
www.youtube.com
October 6, 2026 at 4:05 PM
skillwave.training
A question sent in for our recent 'Ask Ken Anything' (AKA) session tackled a common reporting headache: how do you compare hours logged in a project management system against data from time-tracking software? 🕒
@excelguru.ca walked through a solution he built using #PowerQuery and #PowerPivot. 🧵
Turning Durations Into Hours A student asked how to compare hours logged in a project management system against data from time-tracking software. Ken Puls’ solution used Power Query to clean and transform the data from both sources into a common data type, which could then be more easily compared! (Screenshot of the Power Query Editor displaying the initial time tracker data in the Screen Time columns as miniscule decimals. The Transform > Duration > Total Hours options from the ribbon are highlighted, which then displays the converted values in Screen Time column.) (Skillwave Training logo)
October 6, 2026 at 5:08 AM
remote-work-app.bsky.social
🚀 New Remote Job Alert!
💼 Position: Analytics Developer III
🏢 Company: Horizontal Talent
🌍 Location: USA
📁 Category: Data Analysis
💰 Salary: 115,000 - 115,000 USD
🛠️ Skills: COGNOS, TABLEAU, QLIKVIEW, EXCEL POWERPIVOT, SSRS...
#RemoteJobs #RemoteWork #WorkFromHome #Hiring #JobOpportunity
Appl
October 4, 2026 at 6:00 PM
walkipedia.bsky.social
Nope. I’m out. ✌️
SEC & Schwa WINDOWS NT Learning Perl on Win32 Systems Schwartz, Olso & Christianse WEB DESIGN IN A NUTSHELL NIEDERST Excel 2013 Microsoft COVERS OFFICE 97 & 2000 SECOND EDITION SECOND EDITION Cocoa and Objective-C: Up and Running Stevenson Access Database Design & Programming Excel Pocket Guide Roman Frye Writing Excel Macros with VBA Roman Writing Excel Macros Steven Roman Building Data Models with PowerPivot FERRARI RUSSO Micı Oracle9i™ DUMMIES hp 12c financial calculator Fine 150 519 18 01 Financial Accounting FOURTH edition
September 29, 2026 at 9:19 PM
excelguru.ca
In this new video, I show the different types of blanks that can show up in #PivotTables built from the #DataModel. 🙃 If you work with #Excel PivotTables, #PowerPivot, #DAX measures, or #PowerQuery, this will help you understand where blanks come from and how to deal with them: youtu.be/fnVUJmHUTwc
Why PivotTables Show Blanks — and How to Fix Them
In this video, Ken explains the different types of blanks that can show up in PivotTables built from the Data Model. You’ll see why measure calculations can return blanks when no rows remain after…
youtu.be
September 29, 2026 at 5:24 PM
excelguru.ca
During an AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a #DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
How do you show forecasts monthly without duplicating a DAX measure every single month, or ending up with extra blank columns to hide? Ken Puls’ fix involved two synced PivotTables and a dynamic array HSTACK formula! (Screenshot of a PivotTable with columns labelled End of Month, Sold, Forecast columns for 4 months, and Grand Total. A highlight over the Sold column says, “Show as total” and a highlight over the Forecast columns says, “Show Forecast by Month”) (Skillwave Training logo)
September 15, 2026 at 4:44 PM
seufrall.eurosky.social
Is there any viable Excel alternative capable of doing pivot tables that don’t break?
Or capable of competing with PowerQuery and PowerPivot!
I haven’t found any unfortunately.
For Word (including Word) and alternatives, none has a properly working clone formatting between documents.
September 13, 2026 at 9:48 PM
skillwave.training
During the last AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
How do you show forecasts monthly without duplicating a DAX measure every single month, or ending up with extra blank columns to hide? Ken Puls’ fix involved two synced PivotTables and a dynamic array HSTACK formula! (Screenshot of a PivotTable with columns labelled End of Month, Sold, Forecast columns for 4 months, and Grand Total. A highlight over the Sold column says, “Show as total” and a highlight over the Forecast columns says, “Show Forecast by Month”) (Skillwave Training logo)
September 1, 2026 at 4:04 PM
skillwave.training
Learn how to control sorting and filtering when working with #PivotTables connected to the #Excel #PowerPivot #DataModel.
🎥 Here, @excelguru.ca shows how to sort fields properly, including how to use Sort by Column so months appear in Calendar order, not alphabetical: www.youtube.com/watch?v=NShp...
Filtering & Sorting in the Excel Power Pivot Data Model
Learn how to control sorting and filtering when working with PivotTables connected to the Excel Power Pivot Data Model. In this video, Ken shows how to sort fields properly inside the Power Pivot…
www.youtube.com
August 26, 2026 at 4:16 PM
walkipedia.bsky.social
📈📉👨‍💻
TOM RATH BARRY CONCHIE STRENGTHS LEADERSHIP GREAT LEADERS, TEAMS, AND WHY PEOPLE FOLLOW ide Oli RST SIX BOOKS OF THE ELEMENTS OF EUCLID Pickovei POWER PIVOT AND POWER BI The Physies BOOK COLLIE & SINGH EMOTIONAL INTELLIGENCE 2.0 TRAVIS BRADBERRY & JEAN GREAVES SECOND EDITION Access Database Design & Programming Roman O REILL COVERS OFFICE 97 & 2000 Writing Excel Macros Steven Roman O REILLY* Microsoft Excel 2013 Building Data Models with PowerPivot RUSSO microson Writing Excel Macros with VBA O'REILLY SECOND EDITION Programming Perl Wall, Christiansen & Schwartz O REILLY Learning Perl on Win32 Systems Schwartz. Olson O REILLY R for Data Science Wickham & Grolemund O'REILLY® Cocoa and Objective-C: Up and Running Stevenson O RELLY ASSEMBLY LANGUAGE FOR THE IBM PC FAMILY O REILLY Second Edition Oracle9i- SUAL & DUMMIF FOURTHedities Goldrat 173.13円 4224 пи шнС 00. Irwi DR B Financial Accounting STERLING stics, and Grabbie. n Recipes) Power Pivot Power BI The Excel User's Guide to DAX. Power Query Power. B1 & Power Pivot in Excel 2010-2016 Summary Facts 2nd Edition I'm warning you ALL (...) I have NO FILTER. KEEP CALM AND CALCULATE () Rob Collie & Avichal Singh Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 by Rob Collie & Avi Singh MATT > THANKS FOR BEING REVOLUTION PART OF THE DATA LONG NOW i FOR SO POWER ON! Wt c. cel DAX The way I like it (Uh huh, uh huh) CAROD MATI MALAYSIA Maths Skills -KA × / r F (* &) (x & ), Advanced Calculus Sx ax=x+ calculus (x + 4)l + C = Z Complex Numbers cos (2) = sin (7 - 2) • Trigonometrie Functions x+2y =2 • Algebra • Geometry Basic Operations Numbers & Countings Excel Soles Expense Balance 3,532 900 200 519 2,831 123 Primaru School High School University Stage of Life - Job
August 21, 2026 at 12:14 AM
excelguru.ca
Learn how to control sorting and filtering when working with #PivotTables connected to the #Excel #PowerPivot #DataModel. 💡Here, I show how to sort fields properly, including how to use Sort by Column so Month Names appear in the Calendar order instead of alphabetical order.
🎥 youtu.be/NShpoFlUnGo
Filtering & Sorting in the Excel Power Pivot Data Model
Learn how to control sorting and filtering when working with PivotTables connected to the Excel Power Pivot Data Model. In this video, Ken shows how to sort fields properly inside the Power Pivot…
youtu.be
August 18, 2026 at 4:04 PM
excelguru.ca
The #Excel team released 92 new #DAX functions in #PowerPivot a few years ago, the first since Excel 2016! We were very excited about the news as it helped move DAX in Excel closer to parity with #PowerBI. 😁I made this video when they first came out, taking a look: www.youtube.com/watch?v=piGW...
New DAX Functions in Excel Power Pivot - Monkey Shorts Episode 039
For the first time since Excel 2016, we've got new DAX functions in Excel Power Pivot! Fresh to Office Insiders, the Excel team is moving DAX closer to parity with Power BI. Yes, it will take some…
www.youtube.com
August 14, 2026 at 4:18 PM
skillwave.training
The #Excel team released 92 new #DAX functions in #PowerPivot a few years ago, the first since Excel 2016! We were very excited about the news as it helped move DAX in Excel closer to parity with #PowerBI. 😁 Here, @excelguru.ca had a look when they came out: www.youtube.com/watch?v=piGW...
New DAX Functions in Excel Power Pivot - Monkey Shorts Episode 039
For the first time since Excel 2016, we've got new DAX functions in Excel Power Pivot! Fresh to Office Insiders, the Excel team is moving DAX closer to parity with Power BI. Yes, it will take some…
www.youtube.com
August 13, 2026 at 4:04 PM
excelguru.ca
Ever tried to join 2 tables in an #Excel #PowerPivot (or a #PowerBI) #DataModel and been 🚫 blocked by or warned about duplicate values? A Bridge Table may be just what you need.
💡Here's my preferred recipe to build them in #PowerQuery: www.youtube.com/watch?v=-0JA...

#DataModeling #DataAnalyst
Solve Many to Many Joins Using Bridge Tables - Monkey Shorts Episode 038
If you've ever tried to join two tables in your Excel Power Pivot Data Model (or your Power BI Data Model), and been blocked by or warned about duplicate values, a Bridge Table may be just what you…
www.youtube.com
August 7, 2026 at 4:31 PM
excelguru.ca
During a recent AKA, we ended up in a discussion about a long-standing #PowerPivot quirk where the #PivotTable view displays 1 measure/table until you click away to another table and back again. Another attendee confirmed they'd seen the same behavior for years without realizing it was unusual. 🧵
The Column-Width Trick That Uncovered a Hidden Bug In an ‘Ask Ken Anything’, we discussed a long-standing Power Pivot quirk where sometimes the PivotTable view displays one measure per table until you click on another table and back again. It turns out it comes down to where people write their measures: the Power Pivot editor or the Excel UI dialog (Screenshots of two PivotTables, one displaying 1 measure at the bottom of the table, the other displaying 5 measures. A red callout on the second table says, “Where are all of these?”) (Skillwave Training logo)
August 4, 2026 at 5:09 PM
excelguru.ca
When converting an OLAP-backed #PivotTable (like #PowerPivot) into CUBE formulas, any field in the "Filters" section will pop a message asking if you'd like to convert the Filters or not. Do you know which option to choose? 🤔 Let's look at the difference between them:
Converting Filters to CUBE Formulas - Monkey Shorts Episode 034
When converting an OLAP backed Pivot Table (like Power Pivot) into CUBE formulas, any field in the "Filters" section will pop a message asking if you'd like to convert the Filters or not. Do you…
www.youtube.com
July 10, 2026 at 4:32 PM
excelguru.ca
Ever wanted to grab a single cell of data from your #PowerPivot model? Tired of setting up an entire #PivotTable and using GETPIVOTDATA() formulas to do it? Here's how you can quickly convert your Power Pivot backed PivotTable into 🧊 CUBE formulas, and simplify them:
Breaking Cube Formula Arrays - Monkey Shorts Episode 033
Following on last week's Monkey Shorts video, we are going to look at one potential "gotcha" that can happen when converting a PivotTable into CUBE functions - the array formula. These show up when…
www.youtube.com
June 26, 2026 at 4:52 PM
excelguru.ca
Yesterday was Day 2 of my live #SelfServiceBI Boot Camp in London, which focused on #PowerPivot and #DataModeling. One of the key takeaways is that Facts and Dimensions should always live in separate tables.

Facts are something that can be aggregated! 🧮
Dimensions are how we slice our facts! 🔪
What is a Fact? Something that is aggregated - Could be values or text! Examples - Sum of Amount - Count of Customers Easy to identify - Live in the bottom right corner of the Pivot! (Screenshot of the available PivotTable fields with the Value section at the bottom right highlighted in orange with "It's a Fact!") (copyright Excelguru Consulting Inc.) What is a Dimension? How we slice our Facts Examples - Account Group - Customer Class - Year, Month, Day Easy to identify - Row, Column or Filter Fields (not Values) - Slicers or Timelines If it won’t be aggregated, then it’s a Dimension (Screenshot of the available PivotTable fields with all of the the Dimension fields highlighted in blue, and the Fact field highlighted in orange with "It's a Fact!") (copyright Excelguru Consulting Inc.)
May 20, 2026 at 7:17 PM
excelguru.ca
While it's always been possible to create a table from #PowerPivot-backed #DataModels, it has required some black magic and #DAX knowledge to make it happen. The DAX Table Monkey in our Monkey Tools #Excel add-in builds it for you with just a few clicks. 🐵 Learn more about it at mkyt.ca/daxtable.
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) DAX Table Monkey PivotTables and PivotCharts are a great way to summarize your data, but sometimes you want a good old table. The DAX Table Monkey makes it super easy to create a table from a Power Pivot-backed data model using the no-code/low-code approach that we love to take. (Screenshot of the Pivots and Filters menu with DAX Table Monkey highlighted and an info pop-up that says "What this monkey does: The DAX Table Monkey allows you to build and/or modify customized tables which extract their data directly from the Data Model.") monkeytools.ca
May 13, 2026 at 4:36 PM