In this Monkey Shorts video, Ken Puls demonstrates how to sort one #PowerPivot column by another column in #Excel. Now, your Power Pivot backed PivotTables and Slicers will display in the correct order! 👍 Watch on YouTube: https://buff.ly/3DQpbSj
#ExceTips #DataAnalysis #BusinessIntelligence
#ExceTips #DataAnalysis #BusinessIntelligence
Sorting Power Pivot backed Slicer and Pivots - Monkey Shorts Episode 006
In this episode, Ken demonstrates how to sort one Power Pivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in t...
buff.ly
January 10, 2025 at 5:37 PM
In this Monkey Shorts video, Ken Puls demonstrates how to sort one #PowerPivot column by another column in #Excel. Now, your Power Pivot backed PivotTables and Slicers will display in the correct order! 👍 Watch on YouTube: https://buff.ly/3DQpbSj
#ExceTips #DataAnalysis #BusinessIntelligence
#ExceTips #DataAnalysis #BusinessIntelligence
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
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.
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)](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ihdq52obivvf6sq3lnalnwrv/bafkreihi27usklvjc364pyxfdv3wz6f2zbwdjw5x4s5ik3sufewnwkkshq)
October 27, 2025 at 4:11 PM
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.
In this Monkey Shorts, @excelguru.ca shows how to get your #PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. 🧙
www.youtube.com/watch?v=Sa-z...
www.youtube.com/watch?v=Sa-z...
January 15, 2026 at 5:41 PM
In this Monkey Shorts, @excelguru.ca shows how to get your #PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. 🧙
www.youtube.com/watch?v=Sa-z...
www.youtube.com/watch?v=Sa-z...
In this Monkey Shorts video, Ken Puls demonstrates how to sort one #PowerPivot column by another column in #Excel. Now, your Power Pivot backed PivotTables and Slicers will display in the correct order! 👍 https://buff.ly/3DQpbSj
#ExceTips #DataAnalysis #BusinessIntelligence
#ExceTips #DataAnalysis #BusinessIntelligence
Sorting Power Pivot backed Slicer and Pivots - Monkey Shorts Episode 006
In this episode, Ken demonstrates how to sort one Power Pivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in t...
buff.ly
January 9, 2025 at 4:06 PM
In this Monkey Shorts video, Ken Puls demonstrates how to sort one #PowerPivot column by another column in #Excel. Now, your Power Pivot backed PivotTables and Slicers will display in the correct order! 👍 https://buff.ly/3DQpbSj
#ExceTips #DataAnalysis #BusinessIntelligence
#ExceTips #DataAnalysis #BusinessIntelligence
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)](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:xpiehblln2cworixrwklvoyv/bafkreihi27usklvjc364pyxfdv3wz6f2zbwdjw5x4s5ik3sufewnwkkshq)
November 10, 2025 at 5:22 PM
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
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 how at mkyt.ca/daxtable
#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 how at mkyt.ca/daxtable
November 6, 2024 at 5:33 PM
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 how at mkyt.ca/daxtable
#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 how at mkyt.ca/daxtable
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? 🤔 @excelguru.ca looks at the 2 options:
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 9, 2026 at 4:15 PM
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? 🤔 @excelguru.ca looks at the 2 options:
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
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:
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? I'll show how to quickly convert a Power Pivot backed PivotTable into CUBE formulas. Good bye tabular constraints! 👋 buff.ly/QztVYWO
#ExcelTips
#ExcelTips
Convert PivotTables to Cube Formulas - Monkey Shorts Episode 032
Have you ever wanted to grab a single cell of data from your Power Pivot model? Tired of setting up an entire PivotTable and using GETPIVOTDATA() formulas to...
www.youtube.com
July 11, 2025 at 4:13 PM
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? I'll show how to quickly convert a Power Pivot backed PivotTable into CUBE formulas. Good bye tabular constraints! 👋 buff.ly/QztVYWO
#ExcelTips
#ExcelTips
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.
May 13, 2026 at 4:36 PM
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.
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
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:
In this Monkey Shorts, I show how to get your #PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. 🧙
www.youtube.com/watch?v=Sa-z...
www.youtube.com/watch?v=Sa-z...
January 16, 2026 at 5:20 PM
In this Monkey Shorts, I show how to get your #PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. 🧙
www.youtube.com/watch?v=Sa-z...
www.youtube.com/watch?v=Sa-z...
In this Monkey shorts, I demonstrate how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG...
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
Sorting Power Pivot backed Slicer and Pivots - Monkey Shorts Episode 006
In this episode, Ken demonstrates how to sort one Power Pivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order.
www.youtube.com
December 26, 2025 at 5:12 PM
In this Monkey shorts, I demonstrate how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG...
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
In this Monkey Shorts, I show how you can get your #PivotTable to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. ✨ https://buff.ly/42xaJsE
#ExcelTricks #ExcelTips
#ExcelTricks #ExcelTips
Show Missing Dates in PivotTables - Monkey Shorts Episode 009
In this episode, Ken shows how you can get your PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy...
buff.ly
January 31, 2025 at 6:01 PM
In this Monkey Shorts, I show how you can get your #PivotTable to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. ✨ https://buff.ly/42xaJsE
#ExcelTricks #ExcelTips
#ExcelTricks #ExcelTips
Ever wanted to grab 1 cell of data from your #PowerPivot model? Tired of setting up an entire #PivotTable and using GETPIVOTDATA() formulas to do it? Here's how @excelguru.ca quickly converts a Power Pivot backed PivotTable into 🧊 CUBE formulas, and simplifies 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 25, 2026 at 4:05 PM
Ever wanted to grab 1 cell of data from your #PowerPivot model? Tired of setting up an entire #PivotTable and using GETPIVOTDATA() formulas to do it? Here's how @excelguru.ca quickly converts a Power Pivot backed PivotTable into 🧊 CUBE formulas, and simplifies them:
In this Monkey shorts, Ken Puls demonstrates how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG...
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
Sorting Power Pivot backed Slicer and Pivots - Monkey Shorts Episode 006
In this episode, Ken demonstrates how to sort one Power Pivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order.
www.youtube.com
December 24, 2025 at 6:03 PM
In this Monkey shorts, Ken Puls demonstrates how to sort one #PowerPivot column by another column, so that your Power Pivot backed Pivot Tables and Slicers display in the correct order. 🙌 www.youtube.com/watch?v=F0qG...
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
#ExcelTips #DataModeling #PivotTable #DataAnalytics #BusinessIntelligence
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? @excelguru.ca shows to quickly convert your Power Pivot backed PivotTable into CUBE formulas. Good bye tabular constraints! 👋
Convert PivotTables to Cube Formulas - Monkey Shorts Episode 032
Have you ever wanted to grab a single cell of data from your Power Pivot model? Tired of setting up an entire PivotTable and using GETPIVOTDATA() formulas to...
www.youtube.com
July 10, 2025 at 4:46 PM
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? @excelguru.ca shows to quickly convert your Power Pivot backed PivotTable into CUBE formulas. Good bye tabular constraints! 👋
In this Monkey Shorts, @excelguru.ca shows how to get your #PivotTable to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. ✨ https://buff.ly/42xaJsE
#ExcelTricks
#ExcelTricks
Show Missing Dates in PivotTables - Monkey Shorts Episode 009
In this episode, Ken shows how you can get your PivotTables to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy...
buff.ly
January 30, 2025 at 5:57 PM
In this Monkey Shorts, @excelguru.ca shows how to get your #PivotTable to show dates, even if there are no values present for the chosen Fact/Measure column. It's easy with #PowerPivot backed PivotTables, but regular pivot tables involve a little magic. ✨ https://buff.ly/42xaJsE
#ExcelTricks
#ExcelTricks
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? 🤷♂️
@xlguru.bsky.social looks at the 2 options: www.youtube.com/watch?v=0uQ3...
@xlguru.bsky.social looks at the 2 options: www.youtube.com/watch?v=0uQ3...
Converting Filters to CUBE Formulas - Monkey Shorts Episode 034
YouTube video by Skillwave Training
www.youtube.com
August 15, 2024 at 6:41 PM
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? 🤷♂️
@xlguru.bsky.social looks at the 2 options: www.youtube.com/watch?v=0uQ3...
@xlguru.bsky.social looks at the 2 options: www.youtube.com/watch?v=0uQ3...