Write Your First CUSTOM M FUNCTION in Power BI

Подписаться 217 тыс.

Просмотров 28 тыс.

50% 1

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).
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ 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 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on RU-vid: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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

Наука

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 44

@elijahphilson8878 2 года назад

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 :)

@juanlauroaguirre5646 Год назад

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

@AbouAli01006300091 Год назад

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

@HowtoPowerBI Год назад

Awesome Mohammad :) im very happy you think so!

@rajkumarrajan8059 3 года назад

Excellent Tip. Make the data model more efficient

@partymaschine92 2 года назад

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?

@dennydavise Год назад

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

@kishore_p93 3 года назад

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

@HowtoPowerBI 3 года назад

thank you!!! 😀

@user-bk8db7ud6k 2 года назад

Great example, thanks.

@malvin74s 10 месяцев назад

Right on point! Thank you.

@williamarthur4801 Год назад

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.

@shawnh2446 2 года назад

Absolutely love your videos 👍

@HowtoPowerBI 2 года назад

Thank you sooo much Shawn :) You made my day

@SamehRSameh 2 года назад

Please create special playlist for m language from beginner to advanced

@vlockmedia Год назад

clear, thank you

@louism.4980 Месяц назад

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.

@charlesd820 3 года назад

Excellent Info, Many thanks

@HowtoPowerBI 3 года назад

thank you very much Charles! 😀

@user-ef4oc3vc6r 2 года назад

Thanks

@samirvaghasiya9918 2 месяца назад

Thanks :) Very useful

@HowtoPowerBI 2 месяца назад

Glad it was helpful 😃

@DanielTavares29 3 года назад

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

@HowtoPowerBI 3 года назад

hahaha me 2 ;) especially in the morning 😂

@HansdeCocq 2 года назад

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 ? ?

@AlbrechtJ Год назад

Thanks for a helpful video. Subscribe already.

@HowtoPowerBI Год назад

Super thanks!

@nagaprasanthsn1184 10 месяцев назад

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?

@beenaprasad5815 3 года назад

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 🆘🙏🙏

@DinoAMAntunes 3 года назад

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

@HowtoPowerBI 3 года назад

🙂 yes, will do in one of my next videos

@thebhaskarjoshi Год назад

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

@bryanchaves5691 3 года назад

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??

@HowtoPowerBI 3 года назад

tricky one, maybe you could build a table with users / roles / entitlements and create an inactive relation and then active it in your dax measures. I don't know of a more elegant way of solving it.

@timgray7859 3 года назад

What you describe is exactly the point of RLS. It's relatively easy. Set up a security role with the email column = USERPRINCIPALNAME(). If the user does not appear in the email list, everything will be filtered out.

@bryanchaves5691 3 года назад

Thanks, what Im looking for is more a default filter so users can see other's information but displaying theirs by default

@agustinpena948 Год назад

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

@Random_channel_2023 6 месяцев назад

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.