Topic: DAX
-
At SQLBI, Alberto Ferrari and I spend most of our time sharing our knowledge and expertise in DAX. We have been doing this for years, navigating through conferences, workshops, and videos, encountering many individuals – from eager beginners to seasoned… Read more
-
Another student’s question, another video: how to count how many consecutive days have sales? See how to solve the problem step-by-step! Watch now
-
This article describes the difference between the results of DATEADD and PARALLELPERIOD in DAX. These differences also impact many other time intelligence functions that are syntax sugar of these two. Read more
-
The different results of DATEADD and PARALLELPERIOD in DAX may impact many other time intelligence functions that are syntax sugar of these two. Watch now
-
This article describes the use of the tuple syntax in DAX expressions to simplify comparisons involving two or more columns. Read more
-
Avoid circular dependencies when calculated columns or tables are involved in regular one-to-many relationships. Related articles: https://www.sqlbi.com/articles/blank-row-in-dax/ https://www.sqlbi.com/articles/expanded-tables-in-dax/ Watch now
-
This article describes how to join tables in DAX when there are no relationships in the data model. The data lineage plays an essential role in this scenario. Read more
-
This article describes the practical uses of NATURALLEFTOUTERJOIN and NATURALINNERJOIN in DAX. These functions are not commonly used in DAX because they do not have the same flexibility as the corresponding concepts in SQL. Read more
-
Discover the new DAX Query View introduced in Power BI Desktop November 2023. Spoiler: it is a good feature! Watch now
-
This article describes how to correctly shape a data model and prepare data to use a Sankey Chart as a funnel, considering events related to a customer (contact, trial, subscription, renewal, and others). Read more