Tags
Language
Tags
July 2025
Su Mo Tu We Th Fr Sa
29 30 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Powerquery M Code Language Part4

    Posted By: ELK1nG
    Powerquery M Code Language Part4

    Powerquery M Code Language Part4
    Published 9/2022
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 860.22 MB | Duration: 3h 12m

    Data cleaning and structuring using Powerquery M Code

    What you'll learn
    This is M code Part4 and this course will provide the information on List Generate and List Buffer type of functions
    This is an advance level and one should already know M code very well, especially about Lists and table functions.
    You will learn how to use recursive functions like a loop which can take different inputs every time it runs.
    Advance functions for data analysis and data strucuring.
    Requirements
    Knowledge of M code is required. This is Part4. If you are new, please check three parts before this.
    Description
    Please note that if you have seen previous Parts of M code series then only it will be a fun and clarity. This part 4 is not for beginers . If you know how to use lists, functions and how to write syntax in m code, pls go ahead and take this course.M code Part4 is talking about List.genrate function and how to use it as a function in real life plus other functions also in focuss.Introducing the list generate function in M code.What is a list generate function and how its parameters workWhat is the initial parameter, what is the conditional parameter and execution parameter?How to use list generate function using two variables or even more than two variables and how to know the number of variables we have to use.We have started from a beginning and have tried to explain the Concept of this function is clear step by step.There is a 4th hidden parameter which students never see and infact , even they know they don't know how to use it and what is the use of same.What is the role of an optional parameter in list generate function and how does it work.How to know where do we use square brackets , commas especially in a code where it is using data.How to convert list generate into a function which takes inputs and then connect it with the real dataTable sort function in real dataTable select column functionTable select rows functionHow to combine two columns in a sequence using Mcode interface.How to approach a problem - with function and without function - which one is better

    Overview

    Section 1: Introduction

    Lecture 1 Introducing List Generate function

    Lecture 2 Another example on List Generate

    Lecture 3 How to use Variables in List Generate

    Lecture 4 Use more than two variables in function

    Lecture 5 Secret is out - Optional parameter in list generate - no one knows

    Lecture 6 Find Replace Project for you

    Lecture 7 Behind the Scenes - Know everything- fundamentals

    Lecture 8 Replace all values

    Lecture 9 Convert code into a function

    Lecture 10 Finishing the Task

    Lecture 11 Issues not to be ignored

    Lecture 12 Table Sort function - A project for you

    Lecture 13 Project continues

    Lecture 14 Table Select function

    All those professionals who are data analyst or data scientists and want to learn how we can clean and structure the data we want using M code of Powerquery.