+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: PowerQuery M code language Part2 (/Thread-PowerQuery-M-code-language-Part2)
PowerQuery M code language Part2 - nieriorefasow63 - 12-15-2023
![[Image: 3aaaea44817a3497a6d2df72b705beb2.jpg]](https://i122.fastpic.org/big/2023/1215/b2/3aaaea44817a3497a6d2df72b705beb2.jpg)
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
DOWNLOAD