You can perform all sorts of calculations in a query using calculated fields. You can even add criteria to calculated fields. For example, in the above scenario, you could limit the query output ...

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Learn how Excel’s Power Query can simplify data cleaning, automate tasks, and transform your workflow. Save time and reduce errors!

Learn how to efficiently clean data using Power Query in Microsoft Excel 365 to help improve your data analysis, calculations and spreadsheet ...