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

Power BI User on 05 Jul 2020 23:24:20

RE: Measure Management & DAX Editor

please add "Manage Measures Dialogue" it is very necessary to manage visuals data effectively.

DaveG's profile image Profile Picture

Eugene Niemand on 05 Jul 2020 23:23:20

RE: Measure Management & DAX Editor

Have a look at https://github.com/otykier/TabularEditor

DaveG's profile image Profile Picture

Jack Wells on 05 Jul 2020 23:14:20

RE: Measure Management & DAX Editor

There's a trick you can use to do measure groups:

http://radacad.com/how-to-better-organise-your-power-bi-measures

However would be better if there was a button to create these as this is a very well hidden feature.

DaveG's profile image Profile Picture

Marc on 05 Jul 2020 23:11:08

RE: Measure Management & DAX Editor

This older idea has 500+ votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe

DaveG's profile image Profile Picture

Marc on 05 Jul 2020 23:11:08

RE: Measure Management & DAX Editor

This older idea has 500+ votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe

DaveG's profile image Profile Picture

DaveG on 05 Jul 2020 23:08:59

RE: Measure Management & DAX Editor

This is very important and what will take PowerBI to the next level regarding productivity. Today most people who use PowerBI daily have a PBIX with 50+ measures and it becomes very challenging to mantain. AT MINIMUM, adding a GUI with a table of listing each measure would be SUPER HELPFUL!

Here is a mockup: https://i.imgur.com/z6TBOQb.png?1

DaveG's profile image Profile Picture

DaveG on 05 Jul 2020 23:08:59

RE: Measure Management & DAX Editor

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

DaveG's profile image Profile Picture

William Gillett on 05 Jul 2020 22:58:36

RE: Measure Management & DAX Editor

Yes - Manage Measures UI is an critical feature in PowerPivot - should be in PowerBI as well.

DaveG's profile image Profile Picture

Ernest Cook on 05 Jul 2020 22:46:18

RE: Measure Management & DAX Editor

I came to the forum to suggest Clone a measure but filtering on measure I see a ton of minor improvements that together could be rolled into this one - create a measure management UI. I only wish I could vote 50 times :-)

Merged Idea (3)