View this newsletter in your browser

NEW ARTICLE

Optimizing Duplicated DAX Expressions using Variables

This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression.
Read more »


 
COURSES HIGHLIGHT

New York and Calgary

Are you planning a training week on DAX?
Do you want to optimize your DAX?
Don't miss these classes:

New York
• Mar 12-14 - Mastering DAX
• Mar 15-16 - Optimizing DAX
Calgary
• Apr 17-19 - Mastering DAX

 
BI NEWS DIGEST

Power BI Embedded, Power BI Updates Archive, Data Silos, and more...

• Power BI Embedded - January 2018
New features for Power BI Embedded in January 2018: it is now possible to select the visuals to embed for a report, to customize the layout, to include row-level security (RLS) for tiles and dashboards, and to control the loading of embedded content. Read more »
 • Power BI Updates Archive
Microsoft created a page that includes the features released in each of the monthly updates to Power BI Desktop since February 2015. Even if older versions cannot be downloaded, this page is useful to read descriptions and watch videos of features released months ago. Read more »
 • The On-Premises Data Gateway and Power BI - Revisited
Adam Saxton published an updated video for the on-premises Data Gateway and Power BI. It includes details about clusters and Power BI data storage location. If you did not read news about data gateway in the last 12 months, watch this videos to update your knowledge! Watch now »
 • Prefix Image and Shape Titles in Power BI
David Eldersveld shares an interesting consideration about naming convention for bookmarks in Power BI. It is a smart idea to avoid confusion in the Selection pane when there are many objects and only a few of them have associated links. Read more »
 • Preventing Data Silos with Power BI
Patrick LeBlanc shows how to avoid data silos in a very entertaining video. Recommended to all the users who need to understand the difference between publishing a report and publishing just a data model on Power BI service. Watch now »
• Comments & Emails in Power BI with PowerApps
Jason Thomas shows how to integrate Power App in a Power BI report to collect comments and send emails within the report itself. It is a nice proof of concept of what it is possible with this integration. Read more »
• Using your own SQL Queries for Tables in SSAS 2016
Chris Webb shows how to use custom SQL queries as data sources in Analysis Services 2017 and Azure Analysis Services with compatibility level 1400. Read more »

 
SQLBI REPLAY - FEB 12, 2013

Week-Based Time Intelligence in DAX

The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date, year-over-year and so on. However, if you have a special calendar structure such as a 4-4-5 weeks' calendar, you need to write your custom Time Intelligence calculation. In this article, you will learn how to write the required DAX formulas. Read more »