DAX is very powerful but hard for people to learn. It seems like the pieces are there (Filter panel experience, Calculation Groups, etc.) to build a DAX Expression Builder that would allow new users to create more complex DAX expressions easily. Such a builder would include: - Choose expression type (measure, column, or table) - Add one or more variables, each with their own expression - For each variable: o Provide the column and aggregation, or desired measure expression to be performed o Column/Table picker to remove filters o Column picker for filters to replace with options to choose specific values in that column or choose a relative option (e.g., TOPN), similar to the Filter Panel options o Column picker for filters to add with options to choose specific values in that column or choose a relative option (e.g., TOPN), similar to the Filter Panel options o Option to use other defined table variables as filters too - Enter a Return expression (pick a column and aggregation, or define a more advanced expression using any scalar variables defined above) If I was a programmer, I would try to make an External Tool that does this. It seems possible.
2 Comments
- Didier_TERRIENNew MemberHello Pat,
That's a great idea !!!!!
Have a look at Power BI Sidetools V1.2.6 when it will be published (soon) then post issues or discussions in GitHub :
https://github.com/didierterrien/Power-BI-Sidetools - fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Option to set custom width for gridlines OR fixed outer padding
When designing reports, using the align and distribute evenly options in the format pane are useful, however when designing report pages with fixed bleeds between visuals I have to follow these steps...IolaWhiteley3 hours agoAdvocate IINew2Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell4 hours agoNew MemberNew19Views2likes1CommentOption to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir15 hours agoMicrosoft EmployeeNew44Views10likes1Comment