Bidirectional cross-filtering whitepaper

Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI Desktop that allows modelers to determine how they want filters to flow for data using relationships between tables. In SQL Server 2014, filter context of a table is based on the values in a related table. With bidirectional cross-filtering the… Read More »

New role, new location

Recently I started at a new role in the Microsoft BI team as part of the customer engagement team, while it is still part of the larger BI product team at Microsoft it is no longer a active product development role. I loved working on amazing products like PowerPivot, SSAS Tabular, Power BI content packs and… Read More »

Tabular translator for SQL Server 2016 on github

With the just released CTP 3.3 for SQL Server 2016 Analysis Service we can now provide translations to your Tabular models. As you might have seen in the blog post you can export a file from SSDT that can be used to translate the model. But often you want to give this file to someone… Read More »

Dynamic format using DAX

Just a quick blog post today. Someone had a scenario where they wanted to have a different number of decimal points based  on the items on the rows. Initially they wanted to go with a calculated column but it is much easier to do this using the FORMAT function in DAX. Using the FORMAT function… Read More »

DAX now has variable support!

With the latest release of the Power BI designer that now supports measure creation we also snuck in another feature that is very useful in complicated measure scenario’s and for performance optimizations. DAX now supports variables. Lets take a look at what that means.

New version of the Power BI designer now supports DAX

As most of you probably have seen or heard, the Power BI designer now supports some of the Power Pivot features like DAX and renaming columns, formatting etc. Some of the features: Formula bar: Using the new formula bar in the Report view you can create measures by writing formulas in the DAX language. The… Read More »

Sessions at SQLBits

I am very happy to share that I’ll be doing several sessions at the SQLBits conference this year. I will be doing the following sessions: We now have an exciting developer story for Power BI, the session Developing for Power BI I will go into how to write applications for Power BI and show you… Read More »

Power BI news

You probably have heard the news already but we have some exciting information that has been released on the new Power BI service as you, for all the details read the blog post on Microsoft. Some great new functionality that is being released are: – Dashboards that allow you to gain insights in your data… Read More »