“Feb 2024 Latest Feature in Power BI “

1) Visual calculations

A new way of doing calculations has arrived! You can now add calculations directly on your visual using visual calculations, which are DAX calculations that are defined and executed directly on a visual. A calculation can refer to any data in the visual, including columns, measures, or other visual calculations. This approach removes the complexity of the semantic model and simplifies the process of writing DAX. You can use visual calculations to complete common business calculations such as running sums or moving averages. Visual calculations make it easy to do calculations that were previously very hard or even almost impossible to do

1. To use visual calculations while in preview, you need to enable it in Options and Settings ➡️ Options ➡️ Preview features. Select visual calculations and select OK. Visual calculations will be enabled after Desktop is restarted.

2. To add a visual calculation, you first need to select a visual. Next, select the New calculation button in the ribbon:

3. To add a visual calculation, type the expression in the formula bar in the visual calculations edit mode that opens. For example, in a visual that contains Sales Amount and Total Product Cost by Fiscal Year, you can add a visual calculation that calculates the profit for each year by simply typing: Profit = [Sales Amount] – [Total Product Cost].

Additionally, you can easily add a running sum of profit by writing:

Running sum profit = RUNNINGSUM([Profit])

Here is a visual with the two visual calculations we have just created:

Conclusion,
You can use many existing DAX functions in visual calculations. Functions specific to visual calculations are also available, such as RUNNINGSUM, PREVIOUS and MOVINGAVERAGE. Using these and other functions, visual calculations are much easier to read, write and maintain than the current DAX required.