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

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.

DaveG's profile image Profile Picture

Tomislav Mališ on 16 Aug 2020 04:13:44

RE: Measure Management & DAX Editor

This is one of most important things to have. Clients do not understand that we can't do bulk changes or migrations of measures.

DaveG's profile image Profile Picture

Kulchandra Neupane on 16 Aug 2020 04:13:27

RE: Measure Management & DAX Editor

When we work on copies of powerbi and there is minor change in dax but we don't have find replace command for it. It takes too long to go to each dax and make changes.

DaveG's profile image Profile Picture

Francisco Prataviera on 16 Aug 2020 04:12:42

RE: Measure Management & DAX Editor

This would be great!, I would also add the possibility of manually evaluate a portion of the DAX formula for previewing the result (like we can do with F9 in excel)

DaveG's profile image Profile Picture

pkvarga on 16 Aug 2020 04:12:12

RE: Measure Management & DAX Editor

This would be a huge QoL addition to the tool, I hope it will be implemented soon :).

DaveG's profile image Profile Picture

Oliver Prucha on 16 Aug 2020 04:12:11

RE: Measure Management & DAX Editor

Would love this. I'm in the same boat. PBIX file(s) with dozens and dozens of measures and it is unbelievably painstaking to make mass edits to them.

DaveG's profile image Profile Picture

E A Misemer on 16 Aug 2020 04:11:43

RE: Measure Management & DAX Editor

What does "backlog" mean?

DaveG's profile image Profile Picture

René Glaus on 16 Aug 2020 04:11:40

RE: Measure Management & DAX Editor

I defently would really appricate such a function may be with an opportunity to get an overview where These measures are used in what visual.

DaveG's profile image Profile Picture

Menno ten Have on 16 Aug 2020 04:11:32

RE: Measure Management & DAX Editor

Would be handy to include setting the formatting (Data Type / Format) of each measure

DaveG's profile image Profile Picture

Jon on 16 Aug 2020 04:11:08

RE: Measure Management & DAX Editor

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.

Merged Idea (3)