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

[jsh1219881]

9 months and no update for an idea that's #4 on the Top list with 4,000 votes. Idea submitted almost 2 years ago.

[hewilky]

Absolutely a must

[daniel_d_dehave]

I absolutely love this idea and every day I find myself wishing the Measure editor was better in the ways that have been listed. I was just spending a fair amount of time yesterday in the Excel Name Manager and thought that the same type of tool would be great in PBI as well. Also, the current editor is so clunky, to have a Visual Studio style editor with line numbers and better controls over the size as I'm constantly fighting with it opening to nearly the full screen. I'd love to be able to drag the size to a sticky setting. A large portion of the time developing PBI solutions is in the Measure editor and it really would be a huge efficiency gain to get a more robust editor. Thank You!!! and Please!!!

[fbcideas_migusr]

It would also be nice to be able to easily copy measures from one report to another. I sometimes use the same measures over multiple reports. If there was a repository where measures could be copied/maintained, it would make it a lot easier to use many measures over many reports.

[powermeasuresm]

There is a new 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

[dwilliams1]

There are already some great comments on this, but just wanted to reiterate that having a pop up window with enhanced syntax highlighting, find and replace and the ability to enter and tab and all of that without the editor trying to exit would be amazing. Also would be really cool to have all the measures right over in a sidebar that would allow easily selecting and modifying other measures. Supports for repository / favorites / templates / snippets would also be a really cool feature.

[powermeasuresm1]

There is a new 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

[richard_mcmast1]

This is absolutely essential. Any update on ETA?

[signups]

A M A Z I N G. And solves so many annoyances, adds so many features, and it's literally just some UI/UX implementation. CRITICALLY REQIUIRED.

[toby_riley]

Wouldn't if be great if you could write plugin's for Power BI and open up the eco system to other developers. You would get so much more traction. Dave's design is great. Please improve this area. I use Tabular Editor a lot with SASS Tabular and it's is a much better editing experience than Power BI. Issues for me. The Measure editing is very slow and cumbersome and doesn't always accept your edits or new measures. Set formatting, home table, folder, hidden in one place. Duplicate / copy & paste measures. Copy & paste measures across to a different pbix. Search or filter measures. Visualise / List dependencies. Import/export all measures for documentation purposes or transfer to pbix - Although some of this can be done in DAX Editor. Format the DAX statement. Refactor the DAX statement with performance improvement suggestions. Hover over a dependant measure for > 1 sec show's pop-up code view of measure. Snippet manager that you can store your own measure snippets on a folder.aka Regdate SQL Prompt snippets.