This article describes the data model and DAX measures to analyze the effectiveness of campaigns, by separating attributed sales (directly linked to a campaign) from influenced sales (all sales of products participating in campaigns, regardless of attribution). Read more
Three months ago, Microsoft introduced the User-Defined Functions (UDFs) in the DAX language. From the first day, https://daxlib.org has been available to share libraries of functions with the Power BI community. We published DAX Lib with a low profile because… Read more
Should you use RANK or stick with RANKX? In which scenarios is one better than the other? This article provides an in-depth analysis to help readers make informed choices. RANK Returns the rank for the current context within the specified… Read more
This article explains the distinction between model-dependent and model-independent DAX user-defined functions, highlighting how dependencies impact portability and maintenance, and provides guidance on avoiding hidden dependencies and adopting proper naming conventions. Read more