, history mode: On
> Your generated output will be shown here.
Creators
Visualizers
About M (Power Query)
M is the formula language used in Power Query, a data connectivity and preparation tool in Microsoft Power BI. M is employed for shaping and transforming data during the data import process, providing users with powerful capabilities for data cleaning and transformation.
About Formula Generator
What's this?
Describe your desired Excel or Google Sheet formula in simple words, and Data Mentor will attempt to generate it, using AI.
Can save a significant amount of time and effort, and is perfect for learning how to write Excel or Google Sheet formulas.
Usage instructions
Simply provide details about what your Excel or Google Sheet formula should do, and Data Mentor will attempt to provide you with a working formula that fits your description.
Pro tip
Try to be as detailed and precise as possible with your query, as this can greatly affect the quality of the resulted formula.