Skip to main content

Power BI

Needs Votes

Create a DAX Expression Builder

Vote (2) Share
Pat M's profile image

Pat M on 19 Dec 2020 13:40:53

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.

Comments (1)
Pat M's profile image Profile Picture

Didier TERRIEN on 10 Sep 2021 07:56:43

RE: Create a DAX Expression Builder

Hello 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