DAX Nuggets

https://www.daxpatterns.com/parameter-table/  

https://www.sqlbi.com/articles/generating-a-series-of-numbers-in-dax/  

https://www.sqlbi.com/articles/filter-context-in-dax-explained-visually/  

https://dax.guide/  

https://www.sqlbi.com/articles/row-context-in-dax-explained-visually/  

https://www.sqlbi.com/articles/using-generate-and-row-instead-of-addcolumns-in-dax/   This is my favorite DAX for creating a CALENDAR table: Calendar 5 = VAR BaseCalendar = CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2018, 12, 31 ) ) RETURN GENERATE ( BaseCalendar, VAR BaseDate = [Date] VAR YearDate = YEAR ( BaseDate ) VAR MonthNumber = MONTH ( BaseDate ) VAR MonthName = FORMAT ( BaseDate, "mmmm" ) VAR YearMonthName = FORMAT ( BaseDate, "mmm yy" ) VAR YearMonthNumber = YearDate * 12 + MonthNumber - 1 RETURN ROW ( "Day", BaseDate, "Year", YearDate, "Month Number", MonthNumber, "Month", MonthName, "Year Month Number", YearMonthNumber, "Year Month", YearMonthName ) )

https://www.sqlbi.com/blog/marco/2024/12/30/what-happened-in-the-dax-world-in-2024/