Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
PowerQuery M code language Part4 ( 5 hours)
Rating: 4.4 out of 5(37 ratings)
297 students

PowerQuery M code language Part4 ( 5 hours)

Data cleaning and structuring using Powerquery M Code
Created byajay parmar
Last updated 4/2024
English
English [Auto],

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 structuring

Course content

2 sections • 21 lectures • 5h 7m total length

  • Introducing List Generate function11:24

    Power query m code part four introduces list.generate, detailing its initialize, condition, and next parameters, and demonstrates generating sequences from one to ten.

  • Another example on List Generate1:53

    Learn to generate lists in reverse order using List.Generate in PowerQuery M, starting at 100 and decrementing by 1, with examples like 199, 98, 97, and conditions around 50.

  • How to use Variables in List Generate10:58

    Learn how to use two variables in PowerQuery's List.Generate by initializing X and Y with square brackets, setting conditional criteria, and updating both variables with custom increments.

  • Use more than two variables in function13:12

    Learn to build a PowerQuery M function with three inputs that increment x, y, and z at each step while x plus y stays under 50, with optional fourth parameter.

  • Secret is out - Optional parameter in list generate - no one knows11:47

    Explore the optional parameter in Power Query M's list.generate and how the fourth parameter affects final values, using selector and each with practical Excel-like examples.

  • Find Replace Project for you15:04

    Explore how to use the list.generate function in Power Query M language to replace text with text.replace, manage initial values and counters, and retrieve results with list.last.

  • Behind the Scenes - Know everything- fundamentals43:37

    Explore the fundamentals of Power Query M code by building a list-driven replace loop that updates a string using an initial value, counter, and previous-step memory.

  • Replace all values22:41

    Explore replacing all values in a Power Query M table by looping through a replacement list, using to_replace and replace_with with a counter for multiple substitutions.

  • Convert code into a function16:19

    Learn how to convert a power query code block into a reusable function, enabling dynamic, multi-value replacements from a table and invoking the function for successive inputs.

  • Finishing the Task12:09

    PowerQuery m code language part4 shows turning table comments into dynamic inputs via a custom column and prefix function, yielding a single value.

  • Issues not to be ignored11:52

    Investigate replacing words in PowerQuery M code language by ensuring space handling and whole-word matches, addressing single-word cases and back to back lectures with Excel-assisted techniques.

  • Table Sort function - A project for you7:04

    Learn to use the Power Query table sort function in M code to extract top three quantities per reporter, explore sorting by quantity or reporter, and fix common syntax issues.

  • Project continues7:06

    continue the powerquery m project by grouping reporters, summing total quantities, and selecting the top three partners per reporter using table and sort functions.

  • Table Select function7:10

    Learn to use table.select columns to extract ear, reporter, partner, and quantity, then apply top rows to fetch the top three by quantity, preparing data for pivot or normal table.

  • How to Join pair of table fields - Use Mcode instead its ribbon menu21:21

    Learn to join pairs of table fields in Power Query M code, using text.combine with separators, handling numbers, and avoiding manual ribbon merges for scalable concatenation.

  • Using Function - My favorite approach16:35

    Learn to build a reusable Power Query M function with two parameters to concatenate column pairs in the same table, convert numeric fields to text, and customize delimiters.

  • My other Courses links2:01

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 work

  • What 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 data

  • Table sort function in real data

  • Table select column function

  • Table select rows function

  • How to combine two columns in a sequence using Mcode interface.

  • How to approach a problem - with function and without function - which one is better


Who this course is for:

  • 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.

Report abuse