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

Aaron North on 16 Nov 2023 10:58:37

RE: Measure Management & DAX Editor

I really would like to give control of the measure names to the end user, so when a measure name changes, I need the measure name to update too so when it comes to it we have to update every artifact that written in, now it doesn't happen often but its a big worry when the name is update in a table that is also easy to lookup from a Dax, here's an example of what I would want to do Lookup(Measure,1,Measure[Name]) = CALCULATE(SUM(ShiftHoursCal[New Total]))

DaveG's profile image Profile Picture

Michael Barry on 03 Sep 2023 21:58:41

RE: Measure Management & DAX Editor

For managing and editing measures at scale, Tabular Editor is a must-use tool; it works really well. The only measure related functionality that should be added directly into the Power BI Desktop editor is the ability to search in a report to find where measures are being used - this is currently lacking. Equally, there is a massive need to make Power BI Reports manageable as code, similar to what Tabular Editor has done for Datasets. Structure the Report definitions as a folder structure containing JSON defining visuals, formatting, and measures used.

DaveG's profile image Profile Picture

MOD Administrator on 31 Jan 2023 21:26:56

RE: Measure Management & DAX Editor

TEST

DaveG's profile image Profile Picture

Lucian C on 05 Jan 2023 10:08:04

RE: Measure Management & DAX Editor

Great idea!

DaveG's profile image Profile Picture

Andrew Ashurst on 22 Dec 2022 18:55:23

RE: Measure Management & DAX Editor

only 50 or 60 measures........

DaveG's profile image Profile Picture

on 23 Oct 2022 15:27:10

RE: Measure Management & DAX Editor

hhh

DaveG's profile image Profile Picture

John Lt on 28 Jun 2022 19:46:33

RE: Measure Management & DAX Editor

Some companies don't allow third party software because of security issue. Which mean Power BI is seen as a standalone tool. Mesure & table management is most likely a must have asset to not lose a customer for a competing company

DaveG's profile image Profile Picture

Andrew Ashurst on 16 May 2022 16:01:38

RE: Measure Management & DAX Editor

I'm sure the community tools are great. But, like many I'm in a locked down organisational setting and getting access to these would take an effort of persuasion and promotion I just don't have time for. If the "community tools" are approved by you then PBi should ship with them pre-loaded (or at least available to load).

DaveG's profile image Profile Picture

Kieran Leigh on 22 Mar 2022 10:20:00

RE: Measure Management & DAX Editor

The idea "List where a column or measure is used in a report" would be very useful as part of this.Since the encouraged method is to have a separate model and reporting, it would also be helpful to trace dependencies between reports.

DaveG's profile image Profile Picture

Fahad Shamim on 24 Feb 2022 11:39:23

RE: Measure Management & DAX Editor

In SSAS Multi multidimensional, there was an option for editing all measures in script mode. That was awesome and very easy to mange. But in power BI it seems Microsoft is going in reverse direction, that kind of functionality is expected by default.

Merged Idea (3)