The last introduced DAX functions were announced last year :
Visual Calculations Functions which are designed specifically for visual calculations in Power BI and are not applicable in measures, calculated columns, or calculated tables:
- COLLAPSE / COLLAPSEALL: Modify the hierarchy levels displayed in a visual by collapsing specific levels.
- EXPAND / EXPANDALL: Expand hierarchy levels within a visual to show more detailed data.
- FIRST / LAST: Retrieve values from the first or last row of an axis in the visual matrix.
- NEXT / PREVIOUS: Access values from the next or previous row of an axis in the visual matrix.
- MOVINGAVERAGE: Calculate the moving average over a specified number of periods within a visual.
- RANGE: Define a range of rows in the visual for calculations.
- RUNNINGSUM: Compute a cumulative sum across rows in a visual.
- ISATLEVEL: Determine if the current row is at a specific hierarchy level in the visual.
Don't forget that these functions are exclusive to visual calculations and cannot be used in standard DAX expressions.
INFO Functions which are a set of functions providing metadata about the semantic model:
- INFO.VIEW.COLUMNS: Returns information about columns in the model.
- INFO.VIEW.MEASURES: Provides details on measures defined in the model.
- INFO.VIEW.RELATIONSHIPS: Offers insights into relationships between tables.
- INFO.VIEW.TABLES: Lists tables present in the model.
Additional INFO functions include:
- INFO.CALCDEPENDENCY: Displays dependencies among calculations.
- INFO.CATALOGS: Lists catalogs within the model.
- INFO.CHANGEDPROPERTIES: Identifies properties that have changed.
- INFO.EXCLUDEDARTIFACTS: Shows artifacts excluded from the model.
- INFO.FUNCTIONS: Provides information about functions used in the model.
- INFO.LINGUISTICMETADATA: Returns linguistic metadata associated with the model.
- INFO.PROPERTIES: Lists properties of objects within the model.
- INFO.STORAGETABLECOLUMNS: Details columns in storage tables.
- INFO.STORAGETABLECOLUMNSEGMENTS: Provides information on segments of storage table columns.
- INFO.STORAGETABLES: Lists storage tables in the model.
New DAX functions - DAX | Microsoft Learn
What happened in the DAX world in 2024 - SQLBI
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
