expand power query nested formula to steps
In the process of writing a solution, queries with many steps are often obtained. It would be very convenient to get a tool that allows you to merge selected linked steps into one by obtaining an embedded formula. On the other hand, when you need to debug a code that uses nested formulas, it take...
Merge tables with a condition specified in the user interface.
When combining tables, it is often necessary to attach only part of the data on the conditions. Now you have to manually edit the request and this kind of connection becomes too difficult for novice users. It is necessary to add a block with conditions in the table joining interface at the bottom...
AI for PQ query analysis and improving
AI for assessing the quality of the query and suggestions for its optimization before executing the query on a full set of data. Power Query is positioned as a tool that is available to non-professionals. However, this tool in the hands of not qualitatively prepared users can lead to major busin...