See the latest Power BI and SSAS news.
View this newsletter in your browser


DAX 101: Automatic time intelligence in Power BI

This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Read more »



Table and column references using DAX variables

This article describes how to correctly use column references when manipulating tables assigned to DAX variables. Read more »



Upcoming courses

• Last days for Early Bird of Mastering DAX courses:

  New York, NY, US – June 12-14 Early Bird

  Portland, OR, US – June 19-21 Early Bird

  Aarhus, DK – June 18-20 Early Bird

• Learn DAX in July:

  Amsterdam, NL – July 2-4 Early Bird

  Brisbane, AU – July 17-19 Early Bird

  Sydney, AU – July 30-Aug 1 Early Bird

• Learn data modeling in Australia:

  Melbourne, AU – July 23-25 Early Bird



Latest news on BI

• Report commenting for Power BI service and mobile
It is now possible to insert comments in Power BI reports, sharing them with other people in the company to discuss pages or specific visuals. This is a very long awaited feature in many companies. Read more »
• On-premises data gateway May 2019
This month the data gateway update includes an important new feature (Gateway Performance Monitoring) to help investigating in performance issues and bottlenecks in slow refresh activities through the gateway. As usual, upgrading the data gateway is always a good idea to keep it aligned with Power BI Desktop. Read more »
• Extracting all the M code from a Power BI dataset using the DISCOVER_M_EXPRESSIONS DMV
Chris Webb wrote an interesting blog post describing how to retrieve the M code of all the query expressions in a Power BI model. This technique uses the DISCOVER_M_EXPRESSIONS data management view, which unfortunately is only supported in Power BI service and not in Power BI Desktop – but Chris explains how to use this technique even without Power BI Premium!
Read more »

How to learn dax