DAX calculations at visual level of reports

[marco4]

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/

[sani]

For someone just embracing DAX, this makes a lot of common sense. It will underscore Microsoft's new ethos to simply the use of its products, particularly on coding, which it is successfully evangelizing through the no-code/low code power app development. Microsoft should not wait for the sufficient number of votes to be generated before implementing this evolutionary transformation to DAX.

[pbiideas1]

For someone just embracing DAX, this makes a lot of common sense. It will underscore Microsoft's new ethos to simply the use of its products, particularly on coding, which it is successfully evangelizing through the no-code/low code power app development. Microsoft should not wait for the sufficient number of votes to be generated before implementing this evolutionary transformation to DAX.

[ken7]

I think this is right on the money. A beautiful example of a pair of great teachers getting full leverage out of their vast experience. Whether the feature is added to Power BI or not, their description of why they think it is needed is a regular roadmap of how you teach people to use Power BI.

[Keri_Sime]

This is an excellent idea. I regularly program in 3 other languages and have used at least a dozen over time. I cannot for the life of me be bothered to learn another language especially one that has such a narrow use and doesn't look much like the other languages I already use. I generally find Power BI so clunky that I use R visualisations for anything requiring data processing.

[salil_athalye]

Strong support for this idea. Would also love a visual representation of the dependencies between a DAX measure and any underlying base DAX measures that are used.

[saradhi_gollang]

This feature is required for Power BI

[kzandee1]

excellent idea

[melissa_mj1]

Great idea! I have been struggling for days to find some dax formula that gives me an easy table calculation I can do in excel and of course all the models I develop in power bi can only changed by me because other people in the organization does not understand DAX...strong support this idea!

[giovanni_bracci]

Great idea. I am all for it too because Power BI needs it.

[SROTEM]

Hello to the experts ... I just want to mention that this report presentation is built into CLIKVIEW