Skip to main content
Microsoft Idea

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

jsp.almeida1983 on 16 Aug 2020 04:09:48

RE: Measure Management & DAX Editor

Please Please advance this feature asap. Entire world will thank you so much. I’am sure of that.

Happy 2019!!

DaveG's profile image Profile Picture

Power BI User on 16 Aug 2020 04:09:43

RE: Measure Management & DAX Editor

BUY HIGH QUALITY REAL/FAKE PASSPORTS,DRIVERS LICENSE(charlselwatson@gmail.com),ID CARDS,Counterfeits Bank notes,TOEFL,IELTS,TOEIC,SSN,divorc

DaveG's profile image Profile Picture

Power BI User on 16 Aug 2020 04:09:42

RE: Measure Management & DAX Editor

mockup looks great

DaveG's profile image Profile Picture

Rita on 16 Aug 2020 04:09:39

RE: Measure Management & DAX Editor

Mockup looks great! I hope it gets picked up.

DaveG's profile image Profile Picture

Felix Becker on 16 Aug 2020 04:09:01

RE: Measure Management & DAX Editor

'+ a type ahead functionality would be a plus, or kind of "auto fill", e.g. start typing "calc" than press e.g. "Tab" and the editor propose results, like "Calculate".
+ a formula checker (like others already suggested would be great.

I support entire idea. What a great effort DaveG. Thank you. Hope to see something similar soon.

DaveG's profile image Profile Picture

Daniel Aubert D Amico on 16 Aug 2020 04:08:51

RE: Measure Management & DAX Editor

Your Mockup is Fantastic DaveG !
Must have feature!

DaveG's profile image Profile Picture

Jonathan on 16 Aug 2020 04:08:48

RE: Measure Management & DAX Editor

The mockup looks fantastic, I can't believe they haven't even started to implement this yet.

DaveG's profile image Profile Picture

D. Pearce on 16 Aug 2020 04:08:31

RE: Measure Management & DAX Editor

This is a critical issue that is keeping me from migrating several business critical reports from Excel to PowerBI. Having maintained this data for over 7 years, we followed the progression of PowerBI from it's early origins in PowerPivot, creating tons of custom measures with both complex relationships and DAX formulae in their Data Models.

DaveG's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:28

RE: Measure Management & DAX Editor

What? W don't have advanced editor in Power BI? Oh come on...I was about to ditch Excel for Power Pivot and now I have to go back...

DaveG's profile image Profile Picture

Marcelo Silva on 16 Aug 2020 04:08:18

RE: Measure Management & DAX Editor

Best mockup I've seen!! In a fully centralized data storage, a variable/measure that depends on native fields can be dragged across to other PBIX just as natural and whether the new pbix consumes the same native fields then it can attempt the calculation.

Merged Idea (3)