PowerQuery M code language Part2

[nieriorefasow63]

PowerQuery M code language Part2

Last updated 1/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.50 GB | Duration: 4h 19m

Powerquery M code Part2

What you'll 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.

Description
This course is in continuation to M code part 1 which was prepared by me before. Course will not benefit if you do not know M code before.We are talking about inbuilt M functions which are very important in data development like related to dates, lists.We are learning about user defined functions (UDFs). Why and how we can create our own M functions and achieve amazing results in seconds without doing too much work.Discussion on IF functions is discussed in detail . How we can handle the errors using try and catch.Interesting projects are also shared for real experience.

Overview
Section 1: Introduction to PowerQuery M code - PART 2

Lecture 1 What are we covering- A quick demo

Lecture 2 Introduction to IF FUNCTIONS

Lecture 3 IF Functions Part2

Lecture 4 IF Functions Part3

Lecture 5 User-defined Functions - Create own functions - How and Why

Lecture 6 User-defined Functions - Create own functions - How and Why - part2

Lecture 7 User-defined Functions - Part3

Lecture 8 Error handlers

Lecture 9 A project for you- Top3 Salaries

Lecture 10 Super Project for you - Avoid irrelevant rows Example1

Lecture 11 A project for you- How to avoid specific rows - its awesome

Lecture 12 Get Percentage of each column field- List functions use in a great Style

Lecture 13 A project for you- Create Ranking for each of the category - So much learning

Lecture 14 A project for you- Reverse and get the unique Author Books - Simple awesome

Lecture 15 My Courses with links and Coupon Codes - 30 + Series waiting for you

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


HOMEPAGE

[To see links please register or login]

DOWNLOAD

[To see links please register or login]