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
Bulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401971 hour agoFrequent VisitorNew2Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf11 hours agoFrequent VisitorNew48Views3likes2CommentsEventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde12 hours agoSuper UserCompleted1.4KViews6likes4Comments