2585
Provide a simple way to write formulas that work with the data displayed in a visual. For example, the running total of a measure in a table or in a chart according to the sort order of the visual should be something like this:

Running Total = ReportData[Sales] + PREVIOUS ( ReportData[Running Total] )

Where ReportData is the content of the current visual, Sales and Running Total are the names of the columns in the current visual. The user is not expected to know the model content, the calculation can be executed on top of any data currently being displayed.

More details about a proposal for visual calculations in DAX here:
https://www.sqlbi.com/articles/a-proposal-for-visual-calculations-in-dax/
STATUS DETAILS
Under Review

March 2022 update: We are planning to support this, but we currently do not have a timeline

Comments

M

This is very badly needed to allow us to migrate to Power BI embedded from legacy reporting solutions. Other competitors have this functionality. Fingers crossed that this is implemented in 2022!

M

You can now achieve visual calculations using Inforiver for Microsoft Power BI!


Excel-like formula engine and interface makes it extremely user friendly. Check out these videos for more details - calculated columns and rows and calculated measures.


You can also leverage one-click calculations such as running totals, % contribution to parent/grand total, overall ranking, ranking within group etc. Inforiver also offers no-code budgeting, allocations, what-if simulations and forecasting capabilities and more.




M

Yes ... in a matrix, it should be possible to just write a measure in column 3 = Column(2) / Column(1) .. Qlik has this

M

Calculations used in visuals would greatly improve performance of DQ mode as there wouldn't be need to go to database for each and every derived calculation.

M

This would be a fabulously huge visual solution.

M

I really like this idea, this will give better separation of the reporting model measures versus the semantic model calculations or measure

M

Yes, indeed. XLCubed is a good alternative. It allows the creation of calculations at the visual (table) level.

M

As an Accountant/Finance type, I’m finding it difficult to convince others in my field to invest what they would need to in DAX. Calculations at a visual level would bring this group functionality without having to make the full investment in DAX upfront. My hope would be that this would bring better adoption from a broader business group.

M

Or ... use a client like XLCubed which embraces Excel. No need to wait for future enhancements. Available today!

M

Perhaps a more DAXy step in a similar direction would be to add ordered iterators. Think of SQL's LAG operator but inside a DAX iterator function. While adding the concept of ordering is likely non-trivial under the hood, it would definitely help with Running Total, as well as any other path dependent calculations. I've created an idea with another use case and a possible syntax at

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40647124-ordered-iterators