Skip to main content

Power BI

Completed

Measure Management & DAX Editor

Vote (7240) 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

Zoe Douglas (administrator) on 05 Dec 2023 23:44:57

DAX query view is now in public preview in Power BI Desktop which includes a DAX editor and measure management. Deep dive into DAX query view and writing DAX queries | Microsoft Power BI Blog | Microsoft Power BI

Comments (129)
DaveG's profile image Profile Picture

Michael Arons on 11 Sep 2020 12:22:36

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

Didier Terrien on 10 Sep 2020 11:12:21

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

Victor Ombuna on 27 Aug 2020 03:03:01

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

Penny Robards on 24 Aug 2020 20:50:57

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

Ruben Uyterlinde on 19 Aug 2020 12:07:48

RE: Measure Management & DAX Editor

Great idea, should have already been a feature!

DaveG's profile image Profile Picture

Herr B on 16 Aug 2020 04:20:36

RE: Measure Management & DAX Editor

We are still hoping...

DaveG's profile image Profile Picture

PMM on 16 Aug 2020 04:20:18

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

Jon on 16 Aug 2020 04:20:03

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

Toby Riley on 16 Aug 2020 04:19:58

RE: Measure Management & DAX Editor

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.

DaveG's profile image Profile Picture

Narayana Windenberger on 16 Aug 2020 04:19:32

RE: Measure Management & DAX Editor

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

Merged Idea (3)