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

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.

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 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

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, 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

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

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

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

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

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...