Show only the sales for the last 12 months

Recently I was helping someone on the Power BI community who wanted to only see the sales for the last 12 months in his chart, nothing more. Well this is pretty simple using DAX and I decided to use variables as well. The key here is to think about what you really want and see if you can express this using DAX. In this case it is pretty simple: only show the sum of sales...

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 filter context is propagated to a second related table on the other side of a table relationship. This can help...

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 the Power BI desktop. I feel great knowing this is out there in the market and people love it and...

Using groups in Power BI to publish content to production on your schedule.

When developing dashboards and reports for a large group of business users you want to make sure you deploy the right content at the right time. In this article we will look at an approach that allows me to create and maintain dashboards and reports with a group of developers without disturbing the business users using the reports and dashboards and only deploy the changes to them when we deem the dashboard ready. To do...

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 in the business or even a translator. It would be nice if they had something else instead to just enter...

Just moved my blog to Project Nami (Azure WordPress using SQL Azure)

I was finally fed up with the default Azure wordpress set up that uses a MYSQL database so I decided to switch to Project Nami. This is an open source spin off (fork) of  WordPress  that completly rewrote the data access layer to use SQL. Very cool. To get started just go here http://projectnami.org/download/ and click “Deploy to Azure”, this will automatically deploy project nami to your Azure account. Next I moved my blog over...

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 you can return the numerical value any way you want it. Let’s take the following example. I have the several...

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.