Excel PowerQuery M code language - Part 3
Excel PowerQuery M code language - Part 3
This Part 3 series is in continuation to Part2. To understand and make the best use of this part you must have seen part1 and part2. This is mandatory.
We are learning the important date functions in Mcode which helps us to work with dates in any format. We can add days,months, quaters to dates.
We can extract the month, day, year , day of a week using M code date functions.
We can find out the dates falling within a year or month or today date and many more other things.
DateAddDays, DateAddmonth, DateAddQtr, EoMonth, DateIsincurrentmonth etc important functions are covered in detail.
We are discussing about List functions like List Date, List union, List Intersect, List Difference with many practical examples.
How to find out the matching results in more than one tables .
How to union common items in more than one table.
How to find out the non matches in more than one table.
Real Projects showing the importance of List functions mentioned above.
How to use FIND, LEFT, RIGHT, MID Functions in M code .
How to use them in practical situation.
How to check if string has contain a specific word.
How to reverse the strings characters using M code Text reverse.
How to insert characters repeatedly into a string.
How to remove text from a string.
How to find out the length of string.
Convert to lower case or upper case.
How to remove spaces from left or right or all spaces from a string.
How to create a function which has multiple parameters and with that powerquery can change the data. It is a very big project.
ETL (Extract Transform Load) Data using M code - Our third part in an attempt to make you Ninja.
Url: View Details
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.
Rating: 4.55
Level: All Levels
Duration: 6.5 hours
Instructor: ajay parmar
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap