SQLBI Newsletter 25/2017

NEW ARTICLE

This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignoring products introduced afterwards. Read more »

OKViz Update

OKViz visuals updates

We just released a bunch of updates for OKViz visuals to fix several issues. Take a look:

• Card with States v1.4.0
• Smart Filter v1.1.7
• Sparkline v1.1.2
• Bullet Chart v2.1.5
• Synoptic Panel v1.4.7

Please note that these versions are in BETA. In the next weeks they will be published in the AppSource and automatically updated in all the reports that use them.

COURSES HIGHLIGHT

See you in New York (2018)

The first european courses in 2018 will be Amsterdam and London.
If you want to follow a course in US, these are the first ones we scheduled:

New York
• Mar 12-14 - Mastering DAX
• Mar 15-16 - Optimizing DAX

There will be other dates in Europe and US between April and July. We will also deliver courses in Australia in July and August 2018. Watch out updated dates in the next newsletters.

BI NEWS DIGEST

Power BI updates and more...

	• Power BI Desktop December update The Power BI Desktop December update introduces Q&A integrated in the report design experience, plus many other big and small improvements. Enabling description for each attribute is an important step in enriching metadata and usability for report consumers. Read more »
	• TreeViz custom visual The TreeViz is a custom visual that resembles the good old breakdown tree view that was available in ProClarity. Hint: there is a bug if you have blank values in the column you put in Category data. It is a first version, but it fills a gap. Read more »
	• How to use the Correlation Plot visual Siddharth Mehta wrote a nice post explaining how to use the Correlation Plot custom visual made by Microsoft. Probably you need to prepare data for using it in an effective way with existing data models, reading the article you will understand why. Read more »
	• Power BI template to document Power BI Service Prathy Kamasani published a Power BI template that extracts metadata from Power BI service documenting what is published on a tenant. Useful if you have many users publishing datasets and reports. Running it requires administrative rights to run requests through Power BI API, and you have to follow some instructions to enable that. Read more »
	• Azure Analysis Services diagnostic logs Azure Analysis Services can now generate diagnostic logs. The integration with Azure Monitor Resource Diagnostic Logs makes it easy to activate and use the logs. The next step is creating a report of long running queries, and you can do that in Power BI, too. Read more »

SQLBI REPLAY

Calculated Columns and Measures in DAX

One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one. Read more »