Convert Your Query into an M Function | Combine Data from Multiple Excel Sheets in Power BI

In this video I show you how to turn a query into a custom function in Power BI. As an example I combine data from different Excel sheets by reusing a previously built query.
Learn more about power query and how to use M in Power Bi.

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00​ Intro
1:18 Building the query we turn into a function
3:06 Converting a query into a function
5:29 Invoking the function
08:07 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[filipwinski]

Great Video !!! I've been working with Power Query for a long time, but this is the first time I really understand what a custom function is for. Thank you Bas !!!

[atruewild]

I work with Power Query ever day to design data transformations to support business needs. This is the most impactful video I have watched! Thank you! You are a great teacher. Amazing content.

[anuppatil]

Amazing.. everytime I seem to learn something new watching your videos

[joaorataoo]

Very good video!
I never thought of using the steps saved in a process within a query as a function. Very smart!!!

[huser]

Next to the good explanations, tips, and tricks, I just love your enthusiasm and dynamism.
Thx Bas.

[NithinJB]

That was super informative!!! Real Time Saver

[ronniehugo]

This is awesome! Very useful so I subscribed.

[SanketArora]

Very insightful video, Bas. I was looking for this workaround for sometime now. Great content! Your videos are very informative and easy to understand. Thanks!

[yuhooh]

Thanks, your video is exact match I need for my case.

I do have excel workbook contain daily data for each worksheet. when create with custom function it help automated combine all daily data from multiple sheet into one month table.

[azzamsiddiqui]

Very nice. Thanks for explaining it so well.

[xodrinker]

As usual, great content, well explained. Thx.

[PedroCabraldaCamara]

that is so cool!! ( i use the import from folder and duplicate the file if needed)

[rawwwr]

Hello, Bas!
Could you tell me please, why we wanna create a custom function to combine data from multiple sheets?
What about this solution? Append data from all sheets and then clean & transform. I have a feeling that the first one is better, but I can't explain why.

[TomMattle]

Great videos! Where did you learn all of your Power BI knowledge?

[workstuff]

Fantastic video as usual!! I assume you know this but @3:29 instead of deleting all the steps back to the first one, you can instead right click on the 2nd step and choose "Delete Until End".

[GoodJob]

Superb Vid. 👏 I realise it was 2 years ago, but can this be applied some how to Workbooks in a folder?

[julie_chen]

This is Bananas. Saved it for future use, 😊

[tna]

Hi, what if instead of excel workbook, my source is from folder. Contains multiple workbooks. Initially the workbook only contains single sheet. But recently, a new sheet is added and when i refresh, power query didn’t extract the new one. How and where do i have to change the code? Thank you

[firmanwijaya]

Hi thanks for this amazing tutorial is really useful, could you please explain if the data is in another file not another sheet? thank you

[davidjosevarelagarcia]

Great Video, just a question, what is the different between put in ( sheet as table) the name of the funtion and add "as table"? you dont do it, but in others tutorial i have saw it. even after the () put as table, eg. ( sheet as table) as table =>. what the different?