Understanding Power Query M functions

Good data preparation is perhaps the most important success factor in data analysis. If the data layout is not correct, you will continue to fight Excel; must use advanced, very complex Excel formulas; adding unnecessary columns or even duplicating data,....

But if the data is in the right structure, Excel becomes easy. Let's work with Power Query to simplify your work.

   With Power Query, Microsoft has also created a library of functions and formulas for users to learn and learn, apply.... Based on Microsoft's M formula language library,

    I have created excel files that summarize functions and formulas along with specific examples to make it easier and more convenient for us to use Power Query.