The new calendar-based time intelligence functions offer greater flexibility than the classic time intelligence functions. This article describes the DATEADD parameters for controlling different granularity shifts. DATEADD Context transition Moves the given set of dates by a specified interval. DATEADD… Read more
This article shows how to create a DAX measure that displays information from multiple columns in a business entity or transaction, into a single column of a matrix. Read more
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships. Read more
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