Excel

ARTICLE

Local #dax measures in #powerbi reports are not visible from #Excel

You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the ribbon of Power BI publisher for Excel In both cases, you have the ability to choose either a report or

ARTICLE

Leverage Analyze in Excel for your Power Pivot model

Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example, it does

ARTICLE

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

ARTICLE

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

ARTICLE

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

ARTICLE

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

ARTICLE

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

ARTICLE

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,

ARTICLE

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

ARTICLE

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.