Topic: Excel
Possible #powerpivot issue removing Excel 2016 going back to Excel 2013
Today I observed an issue on a notebook where Excel 2016 was installed and then removed, going back to Excel 2013. After this operation, workbooks having a Power Pivot data model were working correctly by navigating data in PivotTables, but any operation Read more
Apply AND instead of OR logic to multiple selection in a slicer #dax #powerpivot #powerbi
I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customers Read more
Power BI Desktop & Excel
The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users: Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file Live Analysis Services Connections Read more
DAX Studio 2.2 released – tracing support for #powerpivot and much else! #dax
Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release: Tracing (query plans and server timings) available for Power Pivot Basic implementation of Intellisense Connect to Multidimensional SSAS servers Support for multiple Power BI Desginer Read more
Issues with July 2014 Office Update and Click-to-Run #excel #powerbi
An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day Read more
Calculate New, Returning, Lost, and Recovered Customers in #dax
Calculating the number of new and returning customers is a recurring question. I would say this is a “classical” Business Intelligence problem, very common in marketing department. I worked on these problems with many customers, with small and large datasets, Read more
Tips for adapting Date table to Power View forecasting #powerview #powerbi
During the keynote of the PASS Business Analytics Conference, Amir Netz presented the new forecasting capabilities in Power View for Office 365. I immediately tried the new feature (which was immediately available, a welcome surprise in a Microsoft announcement Read more

Prepare Data for Power View Forecasting in Power BI
The new forecasting capabilities in Power View for Office 365 has certain requirements for the column used in x-axis. This article provides a guide to make your data model compatible with the new forecasting feature. Read more
Create Excel Dashboards working on Excel for iPad #excel #ipad #dashboard
I recently tried Excel for iPad and tried opening several workbooks. The results are pretty good, but I’ve found that it wasn’t possible to display certain workbooks. For example, opening a workbook that contains many CUBEVALUE formulas, I should have Read more
Connecting to #powerpivot from an external program (such as #Tableau)
Many people requested me how to connect to Power Pivot from an external program, without publishing the workbook on SharePoint or on Analysis Services Tabular. I always said it is not possible (for both technical and licensing reasons), but someone observed Read more