Evaluation context and its transition is one of the hardest concepts in DAX and I would find it extremely helpful, if syntax highlighting would assist us here: Let the colour of the table name show whether the expression will be evaluated: in a row context (so the table name represents the record/current row and a scalar value will be returned, Color: purple). In a filter context (so the table name represents the (eventually filtered) table and a list of its column values is returned instead, Color: gold. Ideally, it would also indicate if a filter is active or not (or can become active once the measure is used in a pivot table). So with an empty filter, there would be no syntax highlighting. I've described this idea in my blogpost here: http://wp.me/p6lgsG-KI
3 Comments
- renaudmassonNew MemberI agree, remembering what each DAX function does, even after 1.5 year using power BI, is just not possible. Excel offers in-line help when typing a function, power BI should be able to do the same
- carlos_kynaslahNew MemberThis is one of the most frustrating parts of using Power BI, the lack of a proper editor & syntax highlighting. Nesting functions gets very ugly very fast without this feature.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Programmatic point-of-failure recovery for Fabric pipelines
The Fabric monitoring UI already supports Rerun → rerun from failed activity. That capability is only reachable by a human clicking in the portal. Please make point-of-failure recovery available to a...EversonElias3 hours agoRegular VisitorNew2Views0likes0CommentsEnable Managed Private Endpoints Support for Microsoft Fabric Capacities Below F64
Managed Private Endpoints in Microsoft Fabric are currently supported only on F64 and higher capacities. Customers using lower capacities, such as F8, cannot establish private connectivity to Azure s...v-tsindhu4 hours agoMicrosoft EmployeeNew7Views0likes0CommentsAccessibility bug: Notebook cell text becomes invisible under Windows 11 High Contrast mode
Any text written inside a Fabric notebook is invisible when Wndows High contrast mode is enables. This applies to cell text only (not the UI). In addition, auto-complete windows are not respecting t...abigb6 hours agoNew MemberNew3Views0likes0Comments