Forum Discussion
Cumulative formula for multiple columns
There may be other options, but I know you can do this with Tabular Editor scripting:
Useful script snippets | Tabular Editor Documentation
If you're like me and not fluent in C#, try using ChatGPT or Claude to help adapt the scripts to exactly what you need.
HI Anonymous ,
Have you tried using the DAX query view? You should be able to write multiple measures into the model at once by using DEFINE and MEASURE keywords, the table the measures are to be saved to, the names and the formula.
Late reply but that is DAX Query view native in Power BI Desktop.
Hello,
If you can move away from creating all of the measures manually for the Pareto charts, you can use visual "Pareto+" to create a graph, table and legend, or you can use "Pareto by sio2Graphs" to produce the graph, no need for measures.
sio2Graphs 😀
I appreciate the thought but my company isn't keen on using third part visuals unless absolutely necessary. Their concern, warranted or not, is that if we build our eco-system on third party visual and then they (the develolpers of the visual) stop supporting it, want to move to a pay to play model or anything else that can disrupt our process, can cause us to miss contractually required reporting.