Skip to main content
Microsoft Idea

Power BI

Needs Votes

Add Custom Column Formula Help

Vote (5) Share
Adam Kruzel's profile image

Adam Kruzel on 15 Dec 2015 20:47:59

In other tools like Tableau and Crystal Reports, when adding a Custom Column/Calculated Field, there is an area that provides functions to use like CASE, ROUND, SUM, etc. Power BI/Power Query provide a link to their general website where users have to spend MORE time searching for what they want. Why not include an easily searchable listbox of functions that can be used along with their purpose, syntax and upon double-clicking, enter the formula in the formula editor where all the user must do is fill out the necessary expressions. In my role I would like to only be able to provide the necessary data to my users and allow them to slice and dice as they see fit. I’ve run into situations where users want to slice and dice, but they don’t have the time to go to your website and search for the functions they want to use rather than just providing them in the Add Custom Column pop up.

Comments (1)
Adam Kruzel's profile image Profile Picture

chadg on 05 Jul 2020 22:25:00

RE: Add Custom Column Formula Help

Yes, would be great to have intelisense, Very used to it in many other tools. On top of that the syntax checker comes back correct even if it is a bad command. So, syntax may be correct, but if it is an invalid command it is confusing that you get an error once you try and run it.