Jul 31, 2023

Comparing different school terms in Power BI

This article describes how to implement the comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or quarters in a calendar, such as seasons or campaigns.  Read more

Mar 22, 2022

Using ALLSELECTED in composite models

Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic and provide the reasons why ALLSELECTED requires special attention.  Read more

Mar 27, 2019

Start learning Data Modeling for free

SQLBI is now offering a new Data Modeling video course: Introduction to Data Modeling for Power BI. This article describes which users will benefit from this learning experience the most, and how to enroll in the course.  Read more