This article describes how to apply different formatting rules at each level of a hierarchy (one rule at the year level, another at the quarter level, another at the month level) using ISINSCOPE in a measure or ISATLEVEL in a… Read more
3 years ago, we wrote our “Generative AI guidelines at SQLBI”. We think it’s time to update them. Over the past 3 years, the world has changed: it is simply no longer possible to avoid using generative AI services for… Read more
In this article, we implement a function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function. REMOVEFILTERS CALCULATE modifier Clear filters from the specified tables or columns. REMOVEFILTERS ( [<TableNameOrColumnName>] [, <ColumnName>… Read more
This article describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller. Read more