Modelling Data (2018 Updates) Purchase the entire course

21 December 2018 · · 139 views

Power BI Course

Modelling Data (2018 Updates)

Jump to a chapter

This video discusses new features in Power BI that are related to the Modelling Data module of this course.

The Data Pane in the main Power BI window offers the ability to filter and sort the data in a table in your dataset.

Also in the main Power BI window there is now a Mark As Date Table button, and this allows you to tell Power BI which table in your dataset is your date table. This means that certain date and time intelligence DAX calculations are much easier to write, and it also affects how Power BI auto-generates hierarchies on certain date columns.

Q&A, the Power BI natural language query feature, also had some useful updates. You can now use it in Power BI Desktop by clicking Ask A Question or double-clicking in some empty space—this allows you to create a new visual by typing a question. You can also add a Q&A button to a page and this allows an end user of the report, after it has been published, to click and ask their own questions when they are viewing the report in the browser.

Log in or purchase access to play the video.

  • Power BI New Features and Course Updates 1-min Free—Watch Now

  • What is Power BI? 59-min Watch with Free Subscription

  • Licensing 8-min

  • Connecting to Data Sources 42-min

  • Connecting to Data Sources (2018 Updates) 23-min

  • Data Import Concepts 55-min

  • Transforming Data with the Query Editor 1-hour 20-min

  • Transforming Data with the Query Editor (2018 Updates) 13-min

  • Advanced Data Loading 49-min

  • Modelling Data 1-hour 10-min

  • Modelling Data (2018 Updates) 14-min

  • DAX and the Data Model 31-min

  • DAX and the Data Model (2018 Updates) 10-min

  • Power BI Desktop vs Excel 37-min

  • Cloud and Desktop Power BI Dashboards and Reports 45-min

  • Power BI Reports (2018 Updates) 40-min

  • Building Reports in Excel 32-min

  • Sharing, Distribution, and Security 42-min

  • Data Refresh 8-min Free—Watch Now

  • Administration and Auditing 11-min Watch with Free Subscription

  • Azure Analysis Services 1-hour 3-min

  • Power BI Premium and Power BI Embedded 36-min Watch with Free Subscription

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo