OK folks, Microsoft have released the next version of Power BI Desktop.
Version: 2.126.927.0 64-bit (February 2024)
In Preview Settings you can now turn on:
Store semantic model using TMDL format
Less elevated user support
And most impressively. Visual calculations!
Understanding visual calculations | Microsoft Learn
There are other things waiting to be discovered in this release too…
As per usual, I will post the official blog post here as when available.
OK, so I found the DAX (?) descriptions that can be found in the formula bar when using Visual Calculations.
COLLAPSE
Retrieves a context with removed detail levels compared to the current context. With an expression, returns its value in the new context, allowing navigation up hierarchies and calculation at a coarser level of detail.
COLLAPSEALL
Retrieves a context with removed detail levels along an axis. With an expression, returns its value in the new context, enabling navigation to the highest level on the axis and is the inverse of EXPANDALL.
EXPAND
Retrieves a context with added levels of detail compared to the current context. If an expression is provided, returns its value in the new context, allowing for navigation in hierarchies and calculation at a more detailed level.
EXPANDALL
Retrieves a context with added detail levels along an axis compared to the current context. With an expression, returns its value in the new context, enabling navigation to the lowest level on the axis, and is the inverse of COLLAPSEALL.
FIRST
The First function retrieves a value in the visual calculation data grid from the first row of an axis.
ISATLEVEL
Report whether the column is present at the current level.
LAST
The Last function retrieves a value in the visual calculation data grid from the last row of an axis.
LOOKUP
The Lookup function allows the user to retrieve a value in a cell by specifying values on columns in the visual calculation data grid.
MOVINGAVERAGE
Calculates a moving average along the specified axis of the visual calculation data grid.
NEXT The Next function retrieves a value in the next row of an axis in the visual calculation data grid.
PREVIOUS The Previous function retrieves a value in the previous row of an axis in the visual calculation data grid.
RANGE
Retrieves a range of rows within the specified axis, relative to the current row.
RUNNINGSUM
Calculates a running sum along the specified axis of the visual calculation data grid.
I found this by running :
EVALUATE
INFO.FUNCTIONS()
In the DAX Query view and looking for 1 in the [VISUAL_CALCULATIONS_INFO] column…
You can also see a full list for all available DAX too.
And here is the official Microsoft blog post: