Comparing cumulative values for events in different periods
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
Digital media content creators have an ethical responsibility to journalistic integrity. All of them do; all of us… including myself. Read more
Almost a year ago, we announced the release of three sections (core concepts, formula engine, and VertiPaq); in November 2023, we released the DirectQuery over SQL section; now, in April 2024, we release the last section of Optimizing DAX about… Read more
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
This pattern describes how to compute week-related calculations such as year-to-date same period last year and percentage growth using a week granularity This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal… More on DAX Patterns
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more