Power BI

Completed

Measure Management & DAX Editor

Vote (7240)

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 (130)

Daniel Otykier on 16 Aug 2020 04:02:03

RE: Measure Management & DAX Editor

For measures alone, you can actually use Tabular Editor https://tabulareditor.github.io/, although it is unsupported. Tabular Editor lets you connect to a running instance of Power BI Desktop, or to open a .pbit file. You can also export/import measure properties (such as format strings, descriptions, expressions) to a .TSV file for batch editing in Excel. See https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets#export-object-properties-to-a-file for more details.

William McNAir on 16 Aug 2020 04:02:03

RE: Measure Management & DAX Editor

ALso would be a good idea to include the ability to check mark which measures should be active. If you dump a copy and paste set of measures from another workbook, you don't want them all to try and resolve to the new set of data tables until you have made the necessary changes to table and column names. Also, a search and replace function for this formula management area would be welcome.

TEEGEE on 16 Aug 2020 04:02:03

RE: Measure Management & DAX Editor

> Imagine needing to create 50 measures: currently you need to press "Create new measure" and edit the formula each one at a time. With this proposed design you can create them once in PowerBI OR quickly in a table in Excel, and then simply paste them all into the existing PBIX or any other going forward.

The ability to paste a whole bunch of measures all into one window (the ability to specify the home table where they will reside would be nice too) would be a KILLER feature for me!!!

Amazing mockup by the way OP.

Jack Wells on 16 Aug 2020 04:01:46

RE: Measure Management & DAX Editor

Your mockup is great! Best work put into an idea so far :)

Didier Terrien on 16 Aug 2020 04:01:45

RE: Measure Management & DAX Editor

Great idea !
Until it will be implemented in Power BI desktop, I share my way to search a string in DAX columns and measures :
https://community.powerbi.com/t5/Desktop/How-to-search-a-string-in-all-DAX-formulas-of-a-Power-BI-desktop/m-p/363257#M164141
This method is not supported by Microsoft but it is very useful. You may even search in different reports and export formulas to Excel easily.