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/

[Christian_Key1]

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!

[DFishell]

Tableau

[gzheng]

Formulas directly in the Table visual! Brilliant! This is also why people like Excel so much. Having this feature will make me move one more step closer to Power BI.

[DFishell]

Not encouraged by it taking two years for Gli Signori SQLBI to get the equivalent of SQL Window Functions or Tableau's Table Calculations on the development roadmap.

[sebastien_ritle]

This would be more than welcome.

The amount of time spent as well as the number of workarounds required (sort order, totals, calculated groups...) to obtain a presentable result really curb the adoption.

Especially since the rest of the app is making significant progress month in month out

[John_Yip1]

I think the new window function OFFSET() may do the tirck?

[Christian_Key1]

Hi. Can we have an update on the planned delivery of this new idea please?

Thanks,

Chris

[Scott_Otoole]

Hello. Is this idea still on the roadmap for Power BI? Our organization and others could benefit greatly from this feature being implemented!

Thanks

[jeroenterheerdt]

Visual calculations are in preview since February 2024: https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/.

Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months.

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