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
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠ enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande10 hours agoNew MemberNew180Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes18 hours agoNew MemberNeed Clarification198Views3likes1Comment