Select Page

Excel Dynamic Arrays And FilterXML

I’ll admit that I’m a bit less excited about Excel dynamic arrays than I was when I last blogged about them. Don’t get me wrong: from a pure Excel point-of-view they are still very cool, but I’ve since found out that the CubeValue function can’t be used with dynamic...

Introducing the new look for Power BI Service

We’re excited to announce a public preview of the ‘new look’ for Power BI service. We’re refreshing the user interface to provide a modern experience that’s simpler and builds on customers’ familiarity with Microsoft products. Simplified action bar, vertical...

The FILTER() Function in DAX

Level: Intermediate FILTER() is one of the most important functions in the DAX language. It is quite a simple function and yet many people are scared off when they see it. In this article I … The FILTER() Function in DAX Read More This post first appeared...