18.6 Write a Simple M Code in Power BI (Power Query) | Power BI Tutorial for Beginners

#pavanlalwani #powerquery #excel #dataanalytics

In this Power BI tutorial, we will learn how to write a small piece of code in Power Query using the M function. Power Query Editor in Power BI provides an easy way to write and manipulate data using M code. We will create a blank query and define the necessary steps to perform an addition operation. The code snippet will assign values to variables A and B, and calculate their sum in variable C. The final output will be displayed as step name "ABC". We will also explore how to modify the code and change the output step. Stay tuned for more Power BI tutorials.
---------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:

📚 200+ MCQs to test your knowledge.
📝 20+ Assignments for hands-on practice.
🔍 11+ Case Studies for real-world insights.
💼 5+ Industry Projects to build your portfolio.
🎓 Course Completion Certificate for your resume.
💡 Tips & Tricks to boost your skills.
🔎 5+ Industry Datasets for practical learning.

Join thousands of professionals who have transformed their careers. Enroll now at 50% off!
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"

#datacleaning #businessintelligence #powerbi #excelfunctions
---------------------------------------------------------
Timestamps:
00:00:03 Introduction to Power Query and Power BI 💡
00:00:19 Creating a blank query in Power Query Editor 🖋️
00:00:42 Defining variables and performing addition in M code 🧮
00:01:12 Assigning values and calculating the output 📊
00:01:42 Final output and step names in Power Query Editor 📝
00:02:08 Viewing formula and output for each step 💻
00:02:34 Modifying and changing values in the code ✏️
00:02:57 Adding additional steps and unused variables ❌
00:03:19 Deleting unnecessary steps in the editor 🔍
00:03:48 Correcting mistake in code and obtaining desired output ✅
00:04:15 Selecting specific output step in Power Query Editor ⚙️

[PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟

👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!


💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼

[rajkumardeshaboina]

I have seen all the 138 videos. Thank you very much PAVAN LALWANI. its wonderful explanation and great experience...

[sahumansi]

Couldn't like the vdos at the time of watching but in 10 minutes liked them altogether. Deserves all respect. Thank you so much sir ❤️❤️

[SVFlatA]

Very Nyccc Sir Apke Bajhase Mae Bahut Kuch Sikh Gaya Ab Power Bi Mae Meri Koi Problem Nahi Hae ☺️ Thank You Sir Thank You So Much And Advance Power Bi Ki Bhi Video Dalo Plz Plz Plz .... thank You ❤️

[ankitgoiya_muggo]

How many topics are left now to complete full Power BI course?

[hasinarafenoarisoa]

thank you so much! Could you make serial videos about M language in POWER BI, please?

[guilhermeferrari]

I have a column for object position overtime on a csv file. I want to create 2 new columns, one for velocity and another for aceleration. For this I need to create a new column for which the values are the variation of the older column. Can M code help me with this?

[rohitjain]

sir, please provide the video for "trick to find 900 m functions"

[raghunadhamara]

Hi experts, I just publish a report for 10 users and except 1 all are able to view.
There is no role change or permission changes .
How can i trouble shoot it . Can anyone please help me with it.
Can you suggest the basic issues we face in work

[mustafahakimi]

when are u going to upload rest of the videos ?

[tharundommeti]

how to get multiple outputs for a=10, b=11, c=a+b d=13, e=17, f=d+e

[codeandsport]

Sir Is it possible to make a document of power query from here and link it with out html file???

[anerishah]

Sir how we can achieve the dynamic reports through slicer please help me

[Mayankcodezz]

Hello sir myself mayank do you need proper youtube thumbnail and everything you need to make your channel professional then please contact... ❤️

[fantouch]

I need help from the community of power BI to create a formula in M code who can help me? // the task is as follow I need to find a Purchase order, that is in a long string (long text). lets say that text is in Column1, the new column must tell me the PO number or say "NO PO", // The conditios are as follow, the PO alwas start with a "2", it has 8 characters in total, it could any ware in the text, because Column1 is text i thing you must compare each of the 7 character after the first "2" with a list from 0-9, it is posible that in the text are many characters "2", so the code must check all the characters in the full text, find the first "2" check the other 7 charactes, if they are not alligen with the conditios, go to the next "2" in the text until finish analizing all the characters in the text string. sometimes you will find a line of more than 8 numbers after the "2" so keep in mind that the 9th character ( could not be a number). Example: "RO21345678SomeRandomText" PO=21345678. Ejample2: "RO2314567890SomeRandomeText" PO="NO-PO" Because 2314567890 it start with "2" but the 9th character is also a number. Ejample3: "SomerandomeText21345678" PO=21345678, The code must have into consideration that the PO could be at the end of the text string, so the 9th character could not be (null character is diferente than {"0", "1", "2", "3", "4", "5", "6", "7", "8", "9"} I have been trying to solve this without any luck, it is time to ask for help, thank you guys in advance.