PowerQuery M code language Part2 (5 hours)

Powerquery Mcode, Data clearning, data transformation using M code functions, Practical case studies

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I Learn?

• You will learn about existing functions in powerquery - Real Project discussed.
• How to create own functions and why we want them in M code world- Basics to Advance using real time based problems.
• IF statements in detail from basic to advance. Like With single criteria to multiple criteria
• How to tackle Errors in powerquery using Try and Catch method
• Several projects which need great conceptual and analytical skills on the use of Table and List functions. Full on Fun.

Requirements

• You should be well aware of M code because this course is not for beginners.
• You may like to see part1 . This is a part2 in continuation to part1.

Target audience

• M code programmers who want to know more in -depth about M code functions and Data management.