Among all the exciting announcements made at Ignite last week, one you may have missed (even in all the Excel-related announcements here) was that dynamic arrays have finally reached GA. Ever since ...

This project demonstrates how to leverage Power BI’s data model inside Excel to create dynamic, flexible, and fully formatted Financial Statements (Income Statement, Balance Sheet, and Cash Flow ...

Have you found this content useful? Use the button above to save it to your profile. In the first part of this series we looked at how some of the changes in Excel 2010 and 2013 have given us new ...

I am a big fan of using Excel cube functions for reporting on Power BI datasets, Analysis Services and Power Pivot: they allow for a lot more layout flexibility than PivotTables when building reports ...