You searched "Excel"
       64 articles of 308 results
article –

Many-to-many relationships in Power BI and Excel 2016

The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article.  Read more

article –

Automate PowerPivot Data Refresh in Excel

In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago.  Read more

article –

Introducing LOOKUPVALUE

This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt.  Read more