#PowerPivot
LightNews LightNews
excelguru.ca
Ever wondered how to make a #PowerPivot-backed #PivotTable suppress rows full of zeros? A student asked that exact question in an AKA session, and turned it into a great learning moment for everyone! I showed a simple #DAX pattern to suppress zeros dynamically so only meaningful values remain. 🧵 1/3
Zero Means Nothing... Literally! Ever wondered how to make a PowerPivot-backed PivotTable suppress rows full of zeros? In our last Ask Ken Anything session, Ken Puls wowed the group with a simple DAX pattern to suppress zeros dynamically so only meaningful values remain. Screenshot of DAX formula: =VAR vAmount = SUM( Sales[Amount] ) VAR vResult = IF( vAmount = 0, BLAND(), vAmount) RETURN vResult (Skillwave Training logo)
November 10, 2025 at 5:22 PM
skillwave.training
#DAX can be intimidating, even for experienced users of #PowerBI and #Excel #PowerPivot. 😫 But our Supercharge Power BI training by expert Matt Allington will walk you through writing and understanding DAX measures, turning you data into actionable insights. 😀 Enroll today at skw-t.com/supercharge
Testimonial The content and structure was perfect for the way I learn. I've been using Power BI almost entirely self taught for the past few months and I can see many areas that I need to fix to become more efficient and with DAX now no longer being a scary language, I'm excited to update my original projects to put the learnings into practice. Matthew G. (5 stars) Supercharge Power BI Online (Caricature of Matt Allington) Developed and delivered by Microsoft MVP alumnus and best-selling author, Matt Allington (Skillwave Training logo) skillwave.training
November 4, 2025 at 6:03 PM
skillwave.training
Another happy student! ⭐️⭐️⭐️⭐️⭐️
Elevate your #FinancialReporting game with our advanced #Excel #PowerPivot course by CPA and FCMA, @excelguru.ca. Learn how to correctly lay out chart of accounts, build P&L measures, and generate Balance Sheet measures using #DAX. Enroll today at skw-t.com/buildfs
Testimonial "The course was clear, complete, and very useful." Pascal I. (5 stars) Building Financial Statements in Excel with Power Pivot (Caricature of Ken Puls) Developed and delivered by Microsoft MVP and Chartered Professional Accountant, Ken Puls (Skillwave Training logo) https://skillwave.training
October 29, 2025 at 4:24 PM
excelguru.ca
Today is Day 2 of my live Munich #SelfServiceBI Boot Camp, where we are focusing on #PowerPivot and #DataModeling. One of the key takeaways is that Facts and Dimensions should always live in separate tables.
A Fact is something that can be aggregated! 🧮
A Dimension is 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 Fields area of a PivotTable, with the bottom right quadrant labeled Values and highlighted with "It's a Fact!") 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 (Screenshots of a slicer, a timeline, and the Filters, Columns, and Rows fields in a PivotTable highlighted with "Dimension". The Values fields in the PivotTable is highlighted with "It's a Fact!") NOTE: If it won’t be aggregated, then it’s a Dimension
October 28, 2025 at 6:49 PM
skillwave.training
Ever wondered how to make a #PowerPivot-backed #PivotTable suppress rows full of zeros? Someone asked that exact question in our last AKA session, so @excelguru.ca demonstrated a simple #DAX pattern to suppress zeros dynamically so only meaningful values remain.
Zero Means Nothing... Literally! iEver wondered how to make a PowerPivot-backed PivotTable suppress rows full of zeros? In our last Ask Ken Anything session, Ken Puls wowed the group with a simple DAX pattern to suppress zeros dynamically so only meaningful values remain. Screenshot of DAX formula: =VAR vAmount = SUM( Sales[Amount] ) VAR vResult = IF( vAmount = 0, BLAND(), vAmount) RETURN vResult (Skillwave Training logo)
October 27, 2025 at 4:11 PM
excelguru.ca
Today is officially #Excel's 40th birthday! 🎂🎈 To celebrate, I'm sharing what I think is one of the best features to be implemented in Excel's last 40 years - the introduction of #PowerPivot. Watch here: youtu.be/2Y7h2kVp9rI

#Excel40
Happy 40th Birthday, Excel!
Happy 40th birthday, Excel! In this video, Ken Puls discusses what he thinks is one of the best features to be implemented in Excel's last 40 years: the introduction of Power Pivot.
youtu.be
September 30, 2025 at 4:08 PM
skillwave.training
Ready to elevate your #DataAnalytics and #BusinessIntelligence skills? 📊 Join today and unlock the full potential of #PowerBI, #PowerQuery, #PowerPivot, and #Excel. Our courses are designed by leading experts in the field—real professionals who’ve been in your shoes. View catalog: skw-t.com/courses
Power BI and Excel training created especially for data professionals (Image of a man by an office window working at a computer with a lamp beside him) (Skillwave Training logo)
September 26, 2025 at 4:31 PM
excelguru.ca
I'm wrapping up the week by teaching for a private client on writing DAX formulas for #Excel #PowerPivot.
So what is #DAX? It's the language used to create powerful measures that allow to aggregate your data and gain better #DataIsights. Here's a little challenge to properly generate cost by line. 🤓
What is DAX? Data Analysis eXpressions - Formula language used to create Measures - How we aggregate our data - Unbelievably powerful One Caution - Not all problems are DAX problems - Not all problems are Power Query - problems - If the DAX is too hard, reshape your data with Power Query - If you need dynamic aggregations, create formulas with DAX Challenge: Generate Cost by Line DAX Formulae: - Units on Hand: =SUM(Inventory[Units]) - Avg Cost: =AVERAGE(Inventory[Last Cost]) - Cost x Line: =[Units on Hand]*[Avg Cost] Problem: Grand Total doesn’t add to SUM of the lines above (Screenshot of PivotTable where the grand total of the Cost x Line column is 1,522.73 with a highlight noting: Shouldn’t this be 1,500.40?) How Iterator Functions Work Formulae: - Regular: =[Units on Hand]*[Avg Cost] - SUMX: =SUMX(Inventory,[Regular]) Example SUMX formula that correctly calculates the total: = SUMX( SUM(1) * AVERAGE(23.95) + SUM(2) * AVERAGE(24.95) + SUM(4) * AVERAGE(23.95) + SUM(4) * AVERAGE(24.95) + SUM(9) * AVERAGE(24.95) )
September 19, 2025 at 5:42 PM
rifkiamil.bsky.social
www.youtube.com/watch?v=JCZn...
-Engine - VertiPaq
1. a box for VertiPaq which connected with
1.1 PowerPivot 2010 Add-In for Excel 2010
1.2 Analysis Services Tabular Mode
1.3 SQL Server 2012 - Columnstore storage
-Acquired
2. Maximal Innovative Intelligence
2.1 MS Data Analyzer (2002) (for OLAP)
Evolutionary History of Microsoft Fabric - Spreadsheets to Lakehouse
YouTube video by Insights & Outliers
www.youtube.com
September 13, 2025 at 8:26 AM
skillwave.training
Another happy student! ⭐️⭐️⭐️⭐️⭐️
Elevate your #FinancialReporting game with our advanced #Excel #PowerPivot course by @excelguru.ca! Learn to correctly lay out chart of accounts, build P&L measures, and generate Balance Sheet measures using #DAX. Enroll today at skw-t.com/buildfs
Testimonial Building Financial Statements in Excel with Power Pivot "I loved the depth of the course: bringing elements together of Power Pivot - Power Query - PivotTables - DAX to make automated financial statements. The recipes are great as well." C.D. (5 stars) (Caricature of Ken Puls) Developed and delivered by Microsoft MVP and Chartered Professional Accountant, Ken Puls (Skillwave Training logo) https://skillwave.training
September 3, 2025 at 4:54 PM
powerbiweekly.endj.in
13 Things I wish I knew about #PowerQuery (when I first started) by John Kerski #PowerPivot #excel #PowerBI www.sqlservercentral.com/articles/13-...
13 Things I wish I knew about Power Query (when I first started)
When I first started with Power Query, it was in Excel, through the Power Pivot feature. I was amazed at how I could transform data with just a few clicks
www.sqlservercentral.com
September 1, 2025 at 8:45 PM
excelguru.ca
If you've ever tried to join 2 tables in your #Excel #PowerPivot (or #PowerBI) Data Model, and been blocked by 🙅 or warned about duplicate values, a Bridge Table may be just what you need. Here's my preferred recipe for creating them: www.youtube.com/watch?v=-0JA...

#DataModeling #DataPreparation
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 29, 2025 at 4:12 PM
kyankyan.bsky.social
#Excel 2016以降に標準搭載されてているローコードツール「 #PowerQuery 」と「 #PowerPivot 」の基本的な使い方から実践的な活用事例まで

【10/18開催】Excel活用で残業削減！業務効率化セミナー - 沖縄県立図書館 www.library.pref.okinawa.jp/gyoji/2025/1...
August 29, 2025 at 3:26 AM
skillwave.training
If you've ever tried to join 2 tables in your #Excel #PowerPivot (or #PowerBI) Data Model, and been blocked by 🙅 or warned about duplicate values, a Bridge Table may be just what you need. Here @excelguru.ca shows his preferred recipe for creating them: www.youtube.com/watch?v=-0JA...
#DataModeling
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 28, 2025 at 5:04 PM
excelguru.ca
Happy 40th birthday, #Excel! In this video, I discuss what I think is one of the best features to be implemented in Excel's last 40 years - the introduction of #PowerPivot. Watch here: youtu.be/2Y7h2kVp9rI

#Excel40
Happy 40th Birthday, Excel!
Happy 40th birthday, Excel! In this video, Ken Puls discusses what he thinks is one of the best features to be implemented in Excel's last 40 years: the introduction of Power Pivot.
youtu.be
August 27, 2025 at 5:32 PM
excelguru.ca
Today, I'm leading another great day of training for CPABC, introducing the use of #DAX in #PowerPivot for gaining enhanced #DataInsights. For example, if you've ever had to generate cost by line on a financial statement, the Iterator function is what you need! 👊

#FinancialAnalysis #ExcelAnalytics
August 19, 2025 at 4:56 PM
excelguru.ca
Do you really need to reference the fully qualified table and measure names for each element you want to query in your CUBE formula? The answer is... maybe? 🤷 Let's look at how much you can trim out, and where it could lead to issues: www.youtube.com/watch?v=eLbO...
#Excel #PowerPivot #DataAnalytics
Creating Concise CUBE Formulas - Monkey Shorts Episode 036
Do you really need to reference the fully qualified table and measure names for each element you want to query in your CUBE formula? The answer is... maybe? This week Ken looks at how much you can…
www.youtube.com
August 15, 2025 at 4:17 PM
skillwave.training
Do you really need to reference the fully qualified table and measure names for each element you want to query in your CUBE formula? The answer is... maybe? 🤷
@excelguru.ca looks at how much you can trim out, and where it could lead to issues: www.youtube.com/watch?v=eLbO...

#Excel #PowerPivot
Creating Concise CUBE Formulas - Monkey Shorts Episode 036
Do you really need to reference the fully qualified table and measure names for each element you want to query in your CUBE formula? The answer is... maybe? This week Ken looks at how much you can…
www.youtube.com
August 14, 2025 at 5:05 PM
excelguru.ca
Today, I'm leading an introductory course on #DimensionalModeling with #PowerPivot for CPABC. One of the first things to understand is how to properly structure your data for #DataModeling and building #BusinessIntelligence solutions. 🔑 The key to this is getting the data into "First Normal Form".
August 12, 2025 at 4:25 PM
jcangaia.bsky.social
Funções VBA principalmente e obviamente caso de dados locais.
No caso da Apple desktop perde VBA, PowerPivoT, graph interactivos
August 6, 2025 at 4:48 PM
excelguru.ca
While it's always been possible to create a table from #PowerPivot-backed data models, 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.
August 6, 2025 at 4:35 PM
jcangaia.bsky.social
Para brincar a sério só mesmo powerpivot com dax....
August 6, 2025 at 10:41 AM
skillwave.training
Struggling to create complex financial statements with #PowerPivot? 😓This advanced #Excel course will guide you through every step and key #DAX patterns behind building everything from P&L measures to Statement of Cash Flows.

Enroll now and save 50% with code SUMMER50. Go to skw-t.com/buildfs50
August 3, 2025 at 4:43 PM
excelguru.ca
If you build #FinancialStatements in #Excel, this is the course for you! I'll guide you through every step in the process of creating a full set of accounts and reports from raw data, leveraging #PowerQuery, #DAX, and #PowerPivot.
Until Aug 31, save 50% with code SUMMER50 - go to skw-t.com/buildfs50
August 1, 2025 at 9:17 PM
excelguru.ca
#PowerPivot in #Excel has incredible potential for #FinancialAnalytics, and I'll show you how to unlock it! Master the art of building financial statements, balance sheets, and more. Enroll today and level up your #FinancialAnalysis skills. 💲 📈
Use code SUMMER50 to save 50%: skw-t.com/buildfs50
July 30, 2025 at 8:22 PM