18.7 Trick to Get 900+ M Function in Power BI (Power Query)

18.7 Trick to Get 900+ M Function in Power BI (Power Query) | Power BI Tutorial for Beginners

Рет қаралды 31,811

Күн бұрын

#pavanlalwani #powerbi #businessintelligence #dataanalytics #powerquery
In this video, we will show you a simple trick to find and understand all 900+ M functions in Power Query. Remembering every function and its syntax can be challenging, but with this easy method, you'll be able to access and comprehend all the available functions in Power Query.
We will guide you through the process of creating a blank query, typing a specific formula, and converting the data into a table. You'll discover how to filter functions based on categories like date, text, or numbers, and even access detailed explanations and examples for each function. Master Power Query and enhance your data transformation skills with this powerful tool.
----------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:
🔗 rb.gy/l9ow5
📚 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!
🎉🔗 rb.gy/l9ow5
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX
🎉 🔗rb.gy/e5qhe
Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"
📥 Download Practice Material from Server 💾:
Don't forget to use the hashtags #powerbi 📊 #datavisualization 📈 #datacleaning 👨‍💼
----------------------------------------------------
Timestamps:
00:03 Introduction 🎬
00:25 New Source ✨
01:06 M Functions 🔍
01:26 Date Functions 📅
02:59 Text Syntax 🔤
03:42 Excel Syntax 📊
04:31 Easy Learning Method 📚
04:45 Conclusion 🎓

Пікірлер: 146

@PavanLalwani Жыл бұрын

🚀 Calling all data enthusiasts! 💼🌟 👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off! 🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d 💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼 🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919

@rebelatrest 3 жыл бұрын

Highly recommend the whole series (one a day for a few weeks) to confirm what you do and do not know.The best training I have seen for Excel Power Queries, introducing lots of easy to use functionality straight from the ribbon!

@akash.deblanq 2 жыл бұрын

Done! All the videos. Loved the series, thank you so much.

@BeingLearner3600 2 жыл бұрын

A lot of respect and love from Lahore Pavan Lalwani, I learned Power BI from First Video 01 to Video 138. I am very thankful to you for this contribution and for giving Opportunity to add a new Tool to my CV like an Expert. Having no words to say more thanking you Pawan Sir.

@sahumansi6949 3 жыл бұрын

Extremely useful and dedicated series. Taught so well and professional. No like subscribe mongering. Nothing extra. Just clear and crisp knowledge. Great work sir great. ❤️❤️❤️❤️❤️

@we3605 3 жыл бұрын

Brilliant Pavan. KZfaq has made learning so easy. And contributors like you are further making great contribution. Thanks for that support.

@PavanLalwani 3 жыл бұрын

Thanks a ton :) All the best.

@sanskargawade7667 11 ай бұрын

Thank You so much sir. Learned lots of things from this series.

@arulraj6776 2 жыл бұрын

I learned a lot from those videos about Power BI. Thank you very much for sharing.

@mandalanenisaigirish6339 3 жыл бұрын

Thank you pavan, I have seen all the videos from top to bottom, these are very helpful and i have learned so much from these...thank you so much

@nandhininandhu4293 3 ай бұрын

Thank you so muchh for this vedio !keep doing more 👍 it's really helpful

@tilakgupta3761 3 жыл бұрын

Really brilliant and Awesome Series, Watched Complete series in 2 days with practice, Great Work !!!

@vidyashree328 3 жыл бұрын

I have completed whole POWER BI series. I learnt lot with your all videos. Thank you so much Sir.

@ranjandas9368 3 жыл бұрын

Excellent way of explanations. All 138 Videos are beautiful. Thank you so much.

@rakeshgoud_hi 2 жыл бұрын

Excellent explanation Sir, done with the entire course its very crystal and clear...thank you so much for making these videos and sharing..will be very grateful to you Sir..thanks for making a difference in our lives...!!🙏🙏

@priyasharmax 2 жыл бұрын

Finally Completed all 138 videos & definitely gained a lot of value. Well Explained! Completed Excel Tutorial from Tutorial Points Channel as well. Thankyou Sir!

@princemurali5509 5 күн бұрын

Excellent work sir....

@pandharpurkar_ 3 жыл бұрын

i have completed this series. thanks a lot Sir. Your explanation and way of teaching is really great. Awaiting for power bi DAX video series. THANKS AGAIN..!

@sinchanacp8842 2 жыл бұрын

Thank you so much for your wonderful teaching :)

@vikashdas1852 3 жыл бұрын

Hello Pavan Sir, hats off to your work. I have watched this entire playlist and learnt alot. More power and success to you.

@sivakavin2872 2 жыл бұрын

❤️Finally We also powerBI developer❤️❤️❤️

@sheriffnayak 3 жыл бұрын

Thank you so much Pavan Sir. I have seen all the videos.. You helped me to boost my career.. Thank you so much, Sir...

@deepakbabu1987 2 жыл бұрын

thank you very much sir for your pbi tutorials. i dont think that somebody will give free tuitorials with material to practice. thanks a lot..

@maheshdama5392 3 жыл бұрын

waiting for other videos sir. I m improving my power bi skills a lot through your videos

@Kiran-eb3rm 3 жыл бұрын

Such a wonderful tutorial Pavan ,will be thankful to you...........

@KrishnaGupta-dd1mo 3 жыл бұрын

Thank you sir , This course is really helpful . Thank you for your support . You and your team have done an excellent job by creating the content, of course, you have explained each point very well and simple manner for easy to understand. Please guide me what to do next after completing this course ?

@monksmind0699 2 жыл бұрын

Tons of thankq and great work brother...

@ehtishamraza2623 3 жыл бұрын

It was a great journey with you learned lot of things you did great

@arulraj6776 2 жыл бұрын

Your videos taught me a lot. I'm eagerly awaiting your DAX make videos.

@AnitaPaulAnI 2 жыл бұрын

thankyou 🙏 for the great teaching

@vinaykumarl3986 3 жыл бұрын

Completed the whole series. Thanks a lot pavan sir...it really help us a lott...❤️

@PavanLalwani 3 жыл бұрын

Hello Everyone, For Other Courses you can find below links. 1. Power BI - kzfaq.info/get/bejne/fp5kiK2flqnNh6M.html 2. Tableau - www.udemy.com/course/tableaupavanlalwani/ 3. Alteryx - www.udemy.com/course/alteryx-for-everyone/ 4. MicroStrategy - www.udemy.com/course/microstrategy2020/ 5. UFT - www.udemy.com/course/hp-uft-qtp-latest-version/ 6. LoadRunner - www.udemy.com/course/hp-loadrunner/

@aratibagwe6776 3 жыл бұрын

tysm sir for the great support ,i learned alot from this course it is really helpful .can you please provide vidio on dax function

@yaswanthbylapudi 3 жыл бұрын

Thanks a Lot Pavan :) You are simply awesome in explaining the classes. I have started learning Power BI with your 1st video in some other channel and now I got into Power BI role. Really awesome and interesting. Once again thanks a lot and I just found this channel and subscribed also. I will shortly complete watching these videos as well.

@aravindareddy6420 3 жыл бұрын

Similarly there is any trick for DAX Functions?

@deniseyu9015 2 жыл бұрын

Thank you for Power BI Tutorial for Beginners 2020!! I have been complete finished all tutorials it is wonderful learning staff!! I have gained/learned so much about Power BI:) However, I didn't find or see anywhere for of how to upgrade Power BI Desktop version for Query Plan? Would you consider to post or teach with tutorial watching thru coming very soon? b/o without Query Plan it's very hard to programming M language and debugging bugs, correct me if I am wrong?

@venkatkarthik2559 2 жыл бұрын

Thanks a lot Pavan Sir, your teaching is so simple and all videos are highly informative.

@gajanandhumal8883 3 жыл бұрын

Awesome ....Thanks for this power query video series.

@ExcelLearn 2 жыл бұрын

Thanks Pavan Sir, I have watched all your videos and I have learnt a lot. Your are Great & Genius. Glad to find a teacher like you :) The way you have created small small videos for each topic, it's different and easy than others.

@PavanLalwani 2 жыл бұрын

Wonderful buddy. Happy for that. Keep learning and applying :) All the best

@sreedevikonanki9350 3 жыл бұрын

Hi Pavan, Learned so many new things from your videos. thanks a lot. And we are expecting videos on DAX also. Kindly post them ASAP.

@santoshpaidi5431 3 жыл бұрын

@pavanlalvani. Extremely thankful for uploading videos. I am learning power bi by seeing your videos

@sharish1701 3 жыл бұрын

Thank you so much sir for the hardwork and efforts you have put to create this amazing course. Lots of best wishes to you.

@davaleswarapusaisampathkum492 3 жыл бұрын

thank you sir for the course, looking more from you

@jaswindersingh-zh8qr 3 жыл бұрын

Finally completed..............thanks Pawan

@harshshah9006 Жыл бұрын

Thnx Sir , learned powerbi from you . Great experience !!

@PavanLalwani Жыл бұрын

Than you so much !!

@deveshkumar2902 2 жыл бұрын

Ohh finally completed the whole series 🙂 thanks a lot Pawan for such amazing sessions. Please clear me one thing if the paid Power BI course on your website includes diffrent study material as compare to youtube and how could I get certification for same ?

@ehtishamraza2623 3 жыл бұрын

You are gonna be my favorite teacher

@sudarshangupta9066 3 жыл бұрын

Thanks a lot! Your videos have really helped me. I wanted to know if there are any certifications available in India that I can do for Power BI?

@MahendraKumar-gr4hk 3 жыл бұрын

Thank you so much Pavan. and i learnt more with all these videos. Thanks again....

@PavanLalwani 3 жыл бұрын

Great. Keep going

@admanojnilanga 3 жыл бұрын

Hi Mr. Pavan Your lessons are very clear and great job. I watched your 138 videos please send me advance lessons link. Many Thanks.

@need2knowtamil249 2 жыл бұрын

Thanks for your Video

@NagaRaju-ew1cz 3 жыл бұрын

Hi Pavan... Your videos are really helpful and understandable... Please add DAX videos 🙏🙏🙏

@chatkara7344 3 жыл бұрын

Hi Sir, could you please let me know when the rest of the videos(Power BI) will be uploaded here. I have watched all 138 and practiced the same. Please suggest the lumpsum time to post it.

@shabbirsarithala35 2 жыл бұрын

it was great to learn with your simple explanations every thing was awesome sir.. i would like to request you to make videos on dax please sir........

@fayazmuhammad5983 3 жыл бұрын

Nice and wonderful series never see such amazing toturials on power BI Keep it up and continue the series

@PavanLalwani 3 жыл бұрын

Thanks Fayaz. Surely will keep doing it

@tomaszbanach4255 3 жыл бұрын

Great content! Thanks

@aniketgupta670 2 жыл бұрын

very well explained sir. thank you so much for this course. this course made my concept very clear .thank you once again.

@PavanLalwani 2 жыл бұрын

My pleasure

@krishnakishorepeddisetti4387 3 жыл бұрын

hi Pavan sir ...can you also create a set of videos on power bi admin portal and different roles (capacity, tenant etc)...will be very helpful

@technoarunav 2 жыл бұрын

WoW...Pawan...Your PowerBI videos are so so useful and clearly taught with clear visualization...I think your hands on session on powerbi are spot on and very nice!! I have subscribed your channel and look forward to more of your videos on other BI tools as well!! Keep up the wonderful work and best wishes!!

@PavanLalwani 2 жыл бұрын

Thank you buddy

@gbalakrishnareddy7002 3 жыл бұрын

Thanks sir. Sir, approximately how many videos left to upload on Power BI?

@aladinsabari8116 3 жыл бұрын

Great job

@dhirajsingh1847 3 жыл бұрын

@pavanlalwani We can do same things with m functions which we can do with DAX so if we learn or practice only one is it ok in power BI

@jalaramatre747 3 жыл бұрын

Thank you sir, Today have completed Power BI course, You and your team have done an excellent job by creating the content, of course, you have explained each point very well and simple manner for easy to understand. Thank you so much for your online video and course. Wish you all the best sir for all your future assignment.

@abhisekhkumar4948 2 жыл бұрын

hey hi jalaram. may i ask how long did it took for you to complete the course. thanks

@jalaramatre747 2 жыл бұрын

@@abhisekhkumar4948 hello abhishek, Less than 2 months

@abhisekhkumar4948 2 жыл бұрын

@@jalaramatre747 thanks jalaram 😊 appreciated

@balajithandavan6842 2 жыл бұрын

Thanks ❤️❤️❤️

@kousikdey62 3 жыл бұрын

Superb 🙏

@shreya7369 2 жыл бұрын

Thank you sir for this whole series. It is a very useful series for beginners to learn Power BI

@akshaypratapsrivastava7726 Жыл бұрын

Ya akhiri video h kya powerbi course ki ?

@NaveenKumar-mg5pt 3 жыл бұрын

Most useful and easy to learn with your teachings sir. your are so extraordinary and talented thanks for the videos sir.

@PavanLalwani 3 жыл бұрын

You are most welcome

@ankitgoiya_muggo8726 3 жыл бұрын

Great

@subhashp4455 2 жыл бұрын

I see that 180 videos were to be uploaded. Please let me know where can I find the other videos..

@Manjureddykanugula 2 жыл бұрын

Hi sir, Thanks for valuable information, have you created any vedios on DAX.

@rumiyaroy3403 3 жыл бұрын

Hi Pawan, Do we have any videos on power BI service specially on gateways and others features in service

@boorashivakumar3763 3 жыл бұрын

Hi sir thanks for everything Pls tell me what the course is best to learn after the power bi

@fatemehsefishahpar3626 Жыл бұрын

Thanks Pavan! That was amaziiing! as always!

@PavanLalwani Жыл бұрын

Glad you liked it!

@raviranjansingh5527 3 жыл бұрын

Great sir ,make more video on m query

@purvabhatia881 2 жыл бұрын

I want to show data in this format. Please suggest. 365.12CR where font size of decimal part and 'CR' is small.

@fayazmuhammad5983 Жыл бұрын

Sir, I Can't able to get M Function! As it required to sign in with an organization or university email

@anurajjena1282 3 жыл бұрын

Respected Sir, I have completed the Microsoft BI now what course I will do, to be a Data Analyst, now I am working as a Monitoring and Evaluation officer at Childfund international but I want to change to the IT sector. Hope for your guidance please (Might be any paid course also I will do) After this what course related to me suggestion, please?

@phonedb1503 3 жыл бұрын

Sir, is this the end of power bi series? You mentioned that you will upload 180 videos.. But only 138 are here till now. Please clarify. Thank you so much for the great series😃😃

@RahulKumar-xj4zo 3 жыл бұрын

I watched this whole tutorial in 4 days. Very well explained. Your videos are engaging and easy to learn. Keep posting good content. Waiting for upcoming videos in this tutorial.

@PavanLalwani 3 жыл бұрын

Thanks, will do! I think you are the fastest person to complete. It took 2 months to complete these series. You finished it in 4 days. Anyways keep Learning. Prepare a dashboard or a report . Put that report on various platforms like linkedin, facebook, whatsapp and let the world know you have learned not just seen or completed videos. That's you fees to be paid or assignment. Consider whatever you think is right.

@RahulKumar-xj4zo 3 жыл бұрын

@@PavanLalwani Sure Pavan, thanks for these words.

@poojalv8131 3 жыл бұрын

@@PavanLalwaniyour the best.your vedios are invaluable ...the best tutor after seeing all your excel,vba,power point,power bi series.. i started to imitate the way you speak ..it is simple and humble

@lohithneerukattu60 3 жыл бұрын

Hi pawan sir ... I watched all your videos about power bi ..I learned a lot from them.... Thankyou so much sir ...

@PavanLalwani 3 жыл бұрын

Wonderful. Now after watching Create some report on some data

@chatkara7344 3 жыл бұрын

@@PavanLalwani Hi Pavan, how much package we can get as a fresher? and which is the best company in NCR who hire and pay good for PowerBI? If you have any references that would be great help

@ajitrajbhar8846 3 жыл бұрын

yeah finally completed Completed the whole series. Thanks a lot, pavan sir. ❤️

@vasimuddinsheikh3766 2 жыл бұрын

How long did it take you to finish this playlist?

@ajitrajbhar8846 2 жыл бұрын

More then month

@vasimuddinsheikh3766 2 жыл бұрын

@@ajitrajbhar8846 Great

@dileepkumar5839 2 жыл бұрын

@@ajitrajbhar8846 bro is this the last video in this playlist or any more videos to this?

@archanaag8085 3 жыл бұрын

Can we have vedios on DAX functions pls....

@ajithkumarchinnathambi6367 2 жыл бұрын

Hi Sir, Please post Dax related videos

@kiranprasad1276 3 жыл бұрын

What about DAX function? Waiting for DAX series from long back even which is not there in your udemy course. I think with out DAX we can't work on Power BI

@shashikumar-wt1qh 4 ай бұрын

Where can i find the sample data for practice?

@hamSo47 3 жыл бұрын

How does one get a job after learning this..? I mean how/where to approach recruiters..?

@vinayakkumar993 3 жыл бұрын

Hello Sir, is this the last video of the course ?

@maheshreddy887 2 жыл бұрын

Can you please upload DAX tutorial related to POWERBI

@RishitUpadhyay Жыл бұрын

=#shared does not work for me for some reason showing an error

@BertandRussell 3 жыл бұрын

Beautifulllllll.....Sir. Thanks a lot.

@PavanLalwani 3 жыл бұрын

Most welcome

@aravindareddy6420 3 жыл бұрын

@@PavanLalwani sir how can I get testing data ( what you used in all those videos)

@raviranjansingh5527 3 жыл бұрын

Sir this series is complted or something is left.

@pareshrahool3048 3 жыл бұрын

You also add portfolio projects in this series

@archanaag8085 3 жыл бұрын

Hi sir, thanks for vedios on power bi but if we also have vedios on DAX functions means , it will be more helpfull to us..

@PavanLalwani 3 жыл бұрын

Sure.

@Yatish1307 3 жыл бұрын

Pls make videos on Dax

@kingrajesh2648 3 жыл бұрын

Would you please make DAX functions classes sir

@akshaypatil2698 3 жыл бұрын

Sir, Please make video tutorial on Dundas BI in hindi...please its a request...!!!

@Paperboat786 3 жыл бұрын

This is complete course of power BI ??

@devinenipradeep7771 3 жыл бұрын

which component mostly used real time in power bi

@sachinpatil-uh2mw 3 жыл бұрын

Hi sir please one video on rolling day or month

@ThePerkyPalak 2 жыл бұрын

Can you please make a video on new updates of power BI of hybrid tables ,it's urgent and it would be great help. If someone knows any video on above topic please let me know in comment section.

@devinenipradeep7771 3 жыл бұрын

Please uplode data modeling relationship videos

@devinenipradeep7771 3 жыл бұрын

How to send power bi reports qa and testing