Discover the features in the new composite models introduced in the December 2020 version of Power BI Desktop in this video by YouTuber SQLBI.

You can connect to a Dataset published on powerbi.com (or to Azure Analysis Services) and add tables, columns, and relationships to an existing data model. You can also mash up local models and one or more remote models.
It is the beginning of a new era.

Curbal shows you how to write if-statements like a pro.

Contents:

  • 00:40 if stamentent in Excel wont work
  • 01:50 Use power query user interface to write if statement
  • 03:00 Nested if-statements
  • 03:38 AND/OR conditions in if statements
  • 04:48 NOT condtition in if statements
  • 05:20 Manage errors in if statements
  • 06:13 Advanced if statements
  • 08:19 Order of evaluation if statements