Skip to main content

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes