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.
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.
I will look at DAX Studio and see if I can sort it out. I'll let you know what I find out.
Late reply but that is DAX Query view native in Power BI Desktop.
I've started looking at the DAX query and it seems as though it will work, but it also seems as though there is a huge learning curve. Good thing I have no plans for the weekend.