Measure Management & DAX Editor

[firstredpepper]

Anyone who uses PowerBI long enough has had a PBIX with 50-60 measures and it has become time consuming and tedious to mantain. In Excel you can do a quick find/replace to edit several formulas - in PowerBI you need to select each one individually. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. I've prepared a mockup for this as well as a DAX Editor. Let me know what you think. Mockup: https://i.imgur.com/z6TBOQb.png?1

[nwind]

Any chance you can include a view that shows which visuals a measure is used in?

[bjoern_behrens]

We are still hoping...

[powermeasuresm]

There is an APP named PMM (Power Mesures Manager) that dose just this in this link you can read all bout it and download the App for free https://powermeasuresm.wixsite.com/pm-m

[jsh1219881]

Over a year ago I wrote this, and still there is no progress: We really need this feature. It is painstaking to have to go through each measure and column one by one, and wait for PowerBI to process changes. In addition, I have to cleanup and reverse engineer many other reports, which often look like spaghetti code, and it's very difficult to click through each. It would save me a ton of time and effort to bulk edit, and see all calc columns and measures in a single window. I would compare the current setup like writing code, and processing changes after each semicolon, rather than when I compile and execute. I know how all of the columns and measures interact, and how to debug any issues. Import and export for calc columns and measures would be amazing. Export to something a text editor could open as well, like csv, json, or maybe even excel. This would allow the group of analysts I work with to easily share standardized measures.

[r_uyterlinde]

Great idea, should have already been a feature!

[probards]

Would be so useful to be able to list which measures utilise a specific field. Further being able to list unused fields would be great. Thank you.

[Victor_Ombuna]

As well as integrating it with VS Code to improve the user experience.

[fbcideas_migusr]

Voted. Meanwhile you may have a look at Power BI Sidetools : https://thebipower.fr/index.php/power-bi-sidetools/ It copies measures and calculated columns/tables to files and opens Visual Studio Code. At the moment it is read only but write access is in test.

[michael_arons]

Is it possible to create variables to control instances where you might have to change many different formulas?

[fbcideas_migusr]

Doesn’t Tabular editor do exact this?