Write Your First CUSTOM M FUNCTION in Power BI

In this video I show how to write your own custom M FUNCTIONS in Power BI. It will enable you to do work more efficiently in the query editor (Power Query).

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

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00​ Intro
1:08 Write your first custom M Function
2:35 Different ways to invoke a function
3:46 Assigning a data type to the input parameters
4:43 Adding multiple input parameters and transformations
7:48 Understanding how Power Query executes M Functions
9:14 Are M Functions really necessary?
11:12​ 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

[elijahphilson]

This is a very well made video! Crisp explanations, well thought out content, intro/body/conclusion, great editing, and the quiet jazz in the background made me want a coffee all the more! Oh, and to practice writing m functions :)

[AbouAli]

SUPER SUPER SUPER LIKE!!!!... You made it easy .. I was completely afraid to touch this area but you really made it easy!
Very well done

[dennydavise]

I follow the second group Baz. Very nice video... hats off to you...

[juanlauroaguirre]

Hey Bas, the way you explain is just SUPERB, thanks a LOT!!!

[rajkumarrajan]

Excellent Tip. Make the data model more efficient

[SamehRSameh]

Please create special playlist for m language from beginner to advanced

[partymaschine]

Of course I am in the second group as well, this is an awesome example of how custom functions are working! thank you very much for this video!!
I like your dialect - is this a dutch dialect?

[kishore_p]

Very useful tip! Thanks for sharing Bas! Love the way you explain ☕

[williamarthur]

Good video, iit all looks so eay when other people do it., I find custom function syntax quite tricky, as in.
( A, B )=> A + B
or
let
Addup = (A, B ) =>
A + B
in
Addup
and that's before you start needing nested let / in statements.

[louism.]

Thank you so much, Bas! Love how you've made it so simple! A quick question, is the performance better using custom function? I.e., if I were to refresh the query, will both methods take pretty much the same amount of CPU time? Thanks agian.

[DanielTavares]

Very nice video!!
I prefer the second one 😅👍

[HansdeCocq]

Nice trick but……..do you store those functions in a kind of library/repository? E.q how do you make those functions maintainable including the different versions ?
?

[nagaprasanthsn]

Hello, I have a scalar valued function in SQL. I need to pass SUM of certain columns from Power BI to get a final result which needs to be displayed. May I know how to achieve that?

[AlbrechtJ]

Thanks for a helpful video. Subscribe already.

[beenaprasad]

Hi is there any to render custom font on client computer without installing that custom font to there pc or laptop .plz show me a way need help 🆘🙏🙏

[thebhaskarjoshi]

7:12 Thinking... How to make second petameter as Optional?

[agustinpena]

why the M code does not follow a sequential order? I find it hard to understand. thanks!

[Random_channel_]

This is quite confusing for a brand new person and I'd like to advise why instead of just leaving it at that. Every time a new query or function is shown, there is nothing showing how is related to the table. The table already had the 'strength' and 'nrbeans' value, but that wasn't advised of when the functions or invokes were being displayed, therefore I'm trying to understand if when the variables are shown are they referencing the column names from the table or are they new variables. Very lost due to that one detail.

[DinoAMAntunes]

Hi Tks, can you provide a example with multiple tables as parameter.

[bryanchaves]

Hey bro, lets say I have a column with emails. Is it possible to filter by default the data based on who logs in without RLS? Maybe using a calculated table??