Quick measures, a new feature Microsoft released in their April Power BI Desktop update, lets you quickly create new measures based on measures and numerical columns in your table. These new measures become part of your model and can be used in any of your charts, just like manually created DAX calculations. You can also see the underlying DAX, and edit it if you need to tweak the results.
You can create measures based on 19 different calculations across five different categories. Let’s take a look at those five different categories.
Aggregate within category
These calculations let you apply different aggregates at different levels in your data. For example, you can sum revenue up to the month level, and then take an average of that total to display at the year level.
The result would look something like this:
The calculations included in the Aggregate…
Microsoft wants to make it easier for businesses to use their data. Otherwise, what’s the point? In SQL Server 2016 you’ll find a virtual tool chest full of features, all with one primary goal: unlocking your data and helping you create new ways of analyzing, visualizing and sharing it.
Building data-rich biz apps
The advent of machine learning and natural language processing made it easier to analyze unstructured data. The challenge was effectively integrating it with structured data, leading to more meaningful discoveries.
Enter SQL Server PolyBase, a feature in SQL Server 2014 that was specific to the Microsoft Analytics Platform System, through which you could access data in a Hadoop Distributed File System. With SQL Server 2016 we cut the strings, making it possible to query data in Hadoop, as well as Azure Blob Storage. Now you can combine the results of your…