Forum Discussion
Cumulative formula for multiple columns
The company that I work for has a requirement for Control Charts and Pareto charts for each of the metrics that we report on. Our current process is to manually create each measures which is extensive. What I would like to do is to use something like Bravo, if not Bravo, to create the code within JSON files that would pre-create the measures. For some context we are looking to move over 80 metrics from Excel to Power BI and I am not looking forward to creating all of these measure by hand. Any suggestions would be appreciated.
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.
10 Replies
- AlexisOlson
Super User
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.
- danextian
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.
- danextian
Late reply but that is DAX Query view native in Power BI Desktop.
sio2GraphsHelper I
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.
Your solution is so great AlexisOlson and danextian
Hi, Anonymous
Thank you so much for raising your questions in the community! If Super's reply solves your question, you can mark it as a "solution" so that other friends who are experiencing similar problems can also find the answer. This will go a long way in helping others in the community. Thank you again for participating!
Best Regards
Jianpeng Li