Excel PowerQuery M code language - Part 3
ETL (Extract Transform Load) Data using M code - Our third part in an attempt to make you Ninja.
4.41 (68 reviews)
598
students
6.5 hours
content
Feb 2024
last update
$54.99
regular price
What you will learn
This is sequel of M code Powerquery and students are requested to first watch Part1 and Part2 also, if they are not expert in M code.
Solving complex Projects using M code user defined function. One of your project is solved.
You will learn how to work with Dates. Adding days, years,quarters will never be a challenge now.
How to use M Functions which helps in extracting the text values using text functions. Know your left, right, mid and Find functions in M Code with practicals.
How to reverse the strings How to remove the characters from a string.
How to insert characters into a string.
How to see if a string contains specific characters or not.
Know your List functions like List dates. LIst union. List difference and do the complex lookups between two or more than two tables without getting into hassle
You will see if you want to link other table headers into another tables , how to do the same. It is so amazing
How to extract months, days, years from a date using date functions. One should know such things as we almost have date fields in every data.
Know how to sum the cumulative numbers using list range function
Student question solved - split year and status
Screenshots
Related Topics
3485842
udemy ID
9/9/2020
course created date
9/3/2021
course indexed date
Bot
course submited by