SQLBI Newsletter #156

NEW ARTICLE

Computing the future value of an investment based on compound growth in DAX

This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding period.
Read more

OKVIZ UPDATE

Smart Filter Pro update

A new version of Smart Filter Pro (v2.1.1) is now available.
It includes minor bug fixes and new features:

Placeholder text color property
Custom sorting for multiple fields

Release notes
Download (free trial)

#156 · Jan 21, 2020

LEARNING

Course calendar

Data modeling

	Apr 15-17 - New York
	Jun 3-5 - Amsterdam

Mastering DAX

	Feb 5-7 - Houston
	Feb 18-20 - Amst
	Mar 11-13 - San Francisco
	Mar 24-26 - Charlotte
	Mar 31-Apr 2 - Munich
	May 12-14 - Amsterdam
	May 13-15 - Calgary
	May 19-21 - Chicago
	Sep 1-3 - Oslo

video courses

	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

LEARNING

Courses highlights

Reach your 2020 goals by learning DAX at one of our live workshops!

• Houston (Feb 5-7)

• San Francisco (Mar 11-13)

• Charlotte (Mar 24-26)

• Munich (Mar 31-Apr 2)

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI refresh scheduling using Outlook and Power Automate Chris Webb shows how to combine Outlook and Power Automate (did you know that's the new name of Microsoft Flow?) in order to design a complete customized Power BI Refresh schedule. Interesting learning experience - we would never have thought of using Outlook this way! Jan 13,2020 · Chris Webb
	• Getting started with the new Power BI Activity Log API Paul Turley shows how to create a Power BI report importing the Power BI Activity Log using Power Shell. You might expect a Power BI-friendly way to do this, but Paul explains why the JSON format is the easier format to deal with in this case. Jan 6,2020 · Paul Turley
	• Importing Power BI Event Activity Log in Power Query Miguel Escobar included the Power BI Event Activity Log API in his Power BI REST API Custom Connector. Easier to use than the Power Shell approach, but we always appreciate having options. Jan 7,2020 · Miguel Escobar
	• How to make DAX Distinct Counts 100x Faster with Aggregations Greg Galloway explains how to optimize distinct count calculations on large Analysis Services data models, where "large" is 18 billion rows. Aggregations are not free, forget clicky-clicky-draggy-droppy here. Jan 4,2020 · Greg Galloway

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.