Tabular editor code#

Can you think of any problems this script can fix? Then, any measurement you reference within the measure formula it was also updated and re-pointed to. I tested this script and am happy to report that it also fixed changes made to all dependent measures. M.Name = m.Name.Replace(FromString,ToString) įromString with the ToString in the measure names*/ Instead of performing text replacement in measure expression, should replace in the measure name, as it's shown in the following. With a little modification, my script can also fix that problem. Now suppose someone decided that it would be better to use the term “income” that “sales”. Let's say you have 50 compasses, all with names like: Change text in all measure namesĭaniil de suggested another use case for me. Note that Replace (from, until) is case sensitive, so you must capitalize correctly and, possibly, repeat for different capital letters within formulas. * Cycle over all measures in model and replaces the M.Expression = m.Expression.Replace(FromString,ToString) Specific usage of the string that you need to change across the entire model.*/ It isĮssential that your FromString and ToString are set to change only the This script will operate over every measure in the model.

So here is the script that I ended up writing. I tested it using the Output debugger () Y, for my surprise, it worked. I thought it was interesting and wondered if there was such a thing as a rope.

Tabular editor code#

As before, i looked at the Wiki and found a line of code as follows: string.Join I was pretty sure that Tabular Editor could do this, but without any language reference, I really only had a hunch to continue. If you have an equivalent obstacle, this is for you. All I'm doing here is creating a use case to demonstrate a fixable roadblock with scripting in Tabular Editor. Please note that it does not matter if you think it is a good idea or a bad idea to have these measurements, or if you think it is a good or a bad idea to make the changes. Now you have 37 measures to edit if you want to proceed with the change. You pretend to have this CALCULATE(,Products='Chains') So instead of this CALCULATE(SUM(Sales),Products='Chains') So now imagine that you want to improve the readability of your measurements. There is 37 subcategories in Adventure Works, therefore suppose you have 37 measurements that look like this. Total Cap Sales = CALCULATE(SUM(Sales),Products='Caps')

Total Brake Sales = CALCULATE(SUM(Sales),Products='Brakes') Total Chain Sales = CALCULATE(SUM(Sales),Products='Chains')

Suppose you have the following measures in the Adventure Works data model. I want to recreate an equivalent obstacle (not the same problem) using Adventure Works and share with you the answer I came up with to fix such problem using Tabular Editor. The same change in all the measures that have the same 'problem'. Briefly, we decided that I was going to bulk edit many measures to change the way they were written. You have a complex Power BI DAX model with literally hundreds of measures.

No problem, there is little innovation, therefore I love it when I encounter an obstacle that needs to be resolved. But as the saying goes, “necessity is the mother of invention”. There may definitely be something in the Wiki and some more in the Microsoft documentation, but deadly non-programmers like me will just have to figure out the rest ourselves, at least for now. Despite this, one thing that Tabular Editor doesn't have is a lot of documentation. Daniel Otykier has done a great job with this wonderful software, and the more I use it, I love the most. I like everything and I learn more every day. Agree, By now you will probably understand that I think Tabular Editor is pretty good.