Marco Russo wraps up the year:
In 2024, DAX added several functions to support visual calculations – a Power BI feature still in preview at the end of the year 2024. These 12 functions cannot be used in measures, calculated columns, nor calculated tables – they can only be used in visual calculations: COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL, FIRST, ISATLEVEL, LAST, MOVINGAVERAGE, NEXT, PREVIOUS, RANGE, and RUNNINGSUM.
Read on to learn more about what Microsoft has done with DAX as a language, as well as what has kept the SQLBI team busy and what’s coming in 2025.