Skip to main content
Microsoft Idea

Power BI

Planned

Measure Management & DAX Editor

Vote (7151) Share
DaveG's profile image

DaveG on 09 Jan 2018 10:55:44

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

Administrator on 18 Oct 2022 00:53:09

Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo

We've been leaning on the community tools like Tabular Editor, DAX Studio, BISM Normalizer, to provide high-end DAX editing capabilities. We don't have any short-term plans to add more DAX management tools to the product, but we'll be looking at ways to better integrate those tools. 

Comments (128)
DaveG's profile image Profile Picture

Richard Power BI User on 16 Aug 2020 04:18:15

RE: Measure Management & DAX Editor

This is absolutely essential. Any update on ETA?

DaveG's profile image Profile Picture

PMM on 16 Aug 2020 04:17:02

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

Dan DeHaven on 16 Aug 2020 04:16:40

RE: Measure Management & DAX Editor

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!!!

DaveG's profile image Profile Picture

Hew on 16 Aug 2020 04:16:38

RE: Measure Management & DAX Editor

Absolutely a must

DaveG's profile image Profile Picture

David Williams on 16 Aug 2020 04:16:35

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

PMM on 16 Aug 2020 04:16:07

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

Rose Ventura on 16 Aug 2020 04:16:04

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

Mike Power BI User on 16 Aug 2020 04:15:53

RE: Measure Management & DAX Editor

This is so fundamental. Please do this Microsoft.

DaveG's profile image Profile Picture

Jon on 16 Aug 2020 04:15:44

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

Viral Tarpara on 16 Aug 2020 04:14:33

RE: Measure Management & DAX Editor

The lack of centralized measure management a key gap in PBI’s ability to act as an enterprise semantic layer. Compare PBI to how Looker, Qlik, Domo, or GoodData treat this issue as a starting point. Get this right and people will be dropping their SAP BO tomorrow.

Merged Idea (3)