I think it would be helpful if there was some sort of formula library where if I don't know the exact syntax of a formula there would be an in-app place where I can find the syntax rather than having to look at a PDF or some other online library.
4 Comments
- Thanks for the feedback, Jared. This is something that we're tracking and expect to improve in a few months. In the meantime, there is a workaround for you which is to create a Blank Query and "type = #shared" in the formula bar. This will list out all available functions and types as a list of records. If you then use "Into Table" in the ribbon, you will be able to use Filter, Sort, etc. as a way of searching for what you want. Not the most usable approach, but will get you a long way until we get the real feature in the product. :)
- Yes, really need that feature. We tested Tableau, and its formula editor is quite clear for our business users. So it will be great to have such editor in Power BI, with categories, explanation and examples for each formula. Also, as for me, it would be interesting to have formulas like SQL Server t-sql operators for relational data sources.
tahmedAdvocate II
Add a formula tab on the ribbon (similar to excel) where you can browse different functions & formulas- Status added:Needs Votes
