How and where to write DAX Measures for Power BI and Excel

  Рет қаралды 76,762

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

Get started with DAX measures in Power BI and Excel.
Download the practice Excel file contianing the data here: www.myonlinetraininghub.com/i...
Go to the DAX Function Reference: docs.microsoft.com/en-us/dax/...
0:00 Introduction
0:19 What is DAX
0:46 What is Power Pivot
1:22 DAX Function Reference
2:42 Where to write DAX measures in Power BI
5:04 Where to write DAX measures in Excel
6:23 Filter Context
7:53 Implicit Measures
9:35 Nesting Functions in Measures
Learn DAX and Power Pivot with Mynda: www.myonlinetraininghub.com/p...
Connect with me on LinkedIn: / myndatreacy

Пікірлер: 89
@sagar5238
@sagar5238 2 жыл бұрын
Highly underrated channel. I learn new things in every video. Thanks a lot.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much, Sagar! Please spread the word about our channel 🙏
@sagar5238
@sagar5238 2 жыл бұрын
@@MyOnlineTrainingHub although I am not a youtuber content creator. But I would like to suggest you to create short videos. Then traction may improve.
@vijayarjunwadkar
@vijayarjunwadkar 2 жыл бұрын
Thank you Mynda for a crisp and short DAX tutorial! Although I know many topics, including this, it's always a pleasure to watch you teach and every time I end up learning a few new things for sure! Loving it, so let the videos keep coming! 😊👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for your support, Vijay!
@shiffamohammed5818
@shiffamohammed5818 2 жыл бұрын
Thank you for the very much simplified to understand and clear explanation of DAX.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it, Shiffa!
@rachaelhanna8523
@rachaelhanna8523 2 жыл бұрын
Simple and succinct explanation of Filters, expression and arguments. If you've ever wondered what these terms actually mean pay close attention from the 14 min mark. Thanks for this Mynda
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for your kind words, Rachael! Please share the video with your co-workers.
@labc2007
@labc2007 2 жыл бұрын
Thank you Mynda, clear, simple and useful leverage knowledge.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it, Luis 😊
@MOHDANWARify
@MOHDANWARify 2 жыл бұрын
One of the best videos for beginners in Dax. Thanks so much
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you think so!
@wayneedmondson1065
@wayneedmondson1065 2 жыл бұрын
Hi Mynda. Lots to learn in DAX! Thanks for the demo and intro. Thumbs up!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Sure is, Wayne!
@johnkuczmanski6012
@johnkuczmanski6012 4 ай бұрын
I followed along using the supplied Excel spreadsheet and learned a lot. Thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Great to hear!
@teoxengineer
@teoxengineer 2 жыл бұрын
So great tutorial Mynda! very powerful and clear.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thank you so much, Emre!
@ozziepilot2899
@ozziepilot2899 11 күн бұрын
Excellent presentation , thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 күн бұрын
Glad it was helpful!
@chrism9037
@chrism9037 2 жыл бұрын
This was excellent, thanks Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you enjoyed it, Chris!
@diegoaduriz9433
@diegoaduriz9433 2 жыл бұрын
Stunning explanation. Thx for sharing!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
So glad you liked it, Diego!
@katarzynakosacka7531
@katarzynakosacka7531 2 жыл бұрын
Thanx for this session! I love your videos.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much 😊
@JHatLpool
@JHatLpool 7 ай бұрын
Nice demonstration and explanations. Thanks !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Glad it was helpful!
@remuslupinhp
@remuslupinhp 4 ай бұрын
Explained like a pro!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Thanks so much 😊
@Chandrajith100
@Chandrajith100 8 ай бұрын
Thanks a lot for the video!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
You’re welcome! 😊
@darrylmorgan
@darrylmorgan 2 жыл бұрын
Hi Mynda!Great Starter Tutorial..Thank You :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for watching, Darryl!
@ghostlyverse2722
@ghostlyverse2722 Жыл бұрын
You always rock making ever think so so easy
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks for your kind words!
@wodibalanakassoukpala2472
@wodibalanakassoukpala2472 2 жыл бұрын
Thanks for this video... Waiting for more videos on DAX from you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
More coming 😉
@JuanHernandez-pf6yg
@JuanHernandez-pf6yg 3 ай бұрын
Very useful. Thank you! Lovely accent too.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Thank you! 😃
@Khan-mc3gi
@Khan-mc3gi Жыл бұрын
You explain in a great way and you helping alot specially who dont know about power b.i u are great👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
So nice of you 😊
@NoTengoIlusiones
@NoTengoIlusiones 2 жыл бұрын
A big Thank you !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My Pleasure :-)
@jps11086
@jps11086 2 жыл бұрын
Thanks for sharing your knowledge😀
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure 😊
@rd98868
@rd98868 2 жыл бұрын
Amazing as always Mynda :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks so much!
@abderrahmaneazibi8056
@abderrahmaneazibi8056 2 жыл бұрын
Many thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure :-)
@fusimonyolo4585
@fusimonyolo4585 2 жыл бұрын
This is future; Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
My pleasure 😊
@KrishnaKumar-zn9kg
@KrishnaKumar-zn9kg 2 жыл бұрын
Like it. Simple explanation.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you think so!
@mogarrett3045
@mogarrett3045 Жыл бұрын
Mynda you're the best
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much 🙏
@mogarrett3045
@mogarrett3045 Жыл бұрын
@@MyOnlineTrainingHub you're always welcome my friend
@kayalha
@kayalha 2 жыл бұрын
Thank you for the very much
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure 😊
@RossMaynardProcessExcellence
@RossMaynardProcessExcellence 2 жыл бұрын
Really good video Mynda. I'd be really interested in your thoughts on the top 5 (or top 10) most useful DAX functions for Excel - perhaps as a video!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Cheers, Ross! Good idea for top DAX functions 😊
@RossMaynardProcessExcellence
@RossMaynardProcessExcellence 2 жыл бұрын
@@MyOnlineTrainingHub Thank you. No commission necessary!
@drewbbc7074
@drewbbc7074 2 жыл бұрын
Nice starter tutorial. For me - DAX studio (developed by an Aussie) was key to writing elegant DAX.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Cheers, Drew!
@Commonzenze
@Commonzenze 2 жыл бұрын
So that's what my name stands for, thanks! 😀
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
😁 Yep!
@ExceluniForAll
@ExceluniForAll 2 ай бұрын
thats great
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 ай бұрын
Glad you liked it 🙏
@GeertDelmulle
@GeertDelmulle 2 жыл бұрын
This little tutorial is deceivingly simple: good for you! :-) Experience tells me that DAX is quite a bit more cryptic and implicit than Excel or PQ, and the logic is quite a bit different from Excel. The user really needs to study DAX in order to get their head around it. For the uninitiated DAX measures (even simple ones) may seem like total nonsense (e.g. the condition [column1]
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Like Excel functions/formulas, DAX too can be simple, but it can also be incredibly complex. The key is to just get started and build from there.
@GeertDelmulle
@GeertDelmulle 2 жыл бұрын
@@MyOnlineTrainingHub …and to learn the DAX-specific concepts, like: row context, filter context, context transition, context “transcendence” (EARLIER), shielding of contexts, difference between iterators and aggregators, etc. A lot of new concepts that Excel users are unaware of. Oh, and here’s another one (I eluded at that above): wrapping a formula in a context (not just a function, even though that is a component of it). …so many new and important things to learn. :-) OK, OK, I may be hinting at the fact that we need more video’s from you guys and gals on the topic. ;-)
@lilianm7151
@lilianm7151 2 ай бұрын
Do you have a tutorial on how to calculate a 3 months average using DAX in Excel when there is a relationship between data and a date table?
@hubertg7100
@hubertg7100 2 жыл бұрын
Amore 💕💕
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked it 😊
@asepridwan3362
@asepridwan3362 2 жыл бұрын
I Will subscribe your KZfaq channel Mrs.thanks from Indonesia
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to have you subscribe!
@asepridwan3362
@asepridwan3362 2 жыл бұрын
@@MyOnlineTrainingHub done👍
@shoctors
@shoctors 2 жыл бұрын
Thank you for breaking it down simply! However, I kept asking myself why you wouldn't just use the Forecast column that was in the data versus building a DAX formula? They both have the same result, right?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
I thought I answered that point at 7:55 when I talked about implicit and explicit measures. I used a basic measure to illustrate the filter context point and then explained that we didn't have to write that measure explicitly. I then went on to demonstrate a more complex measure. That said, many DAX experts recommend that you write all measures explicitly, even those that can be an implicit measure.
@joseluismartincenjor8409
@joseluismartincenjor8409 2 жыл бұрын
Mynda my question is about relationships within your practice Excel file. At about minute 4:30 you get to show the first visuals using the Forecast Costs measure created. Then you filter per IT Area and the values adjust by themselves, nice. However I could not get the same on my side, until I added a one-to-many relationship between the IT Dept. fields in both the Forecast and the Departments sheets. I've repeated the process, and tried to carefully copy all your steps, but clearly I'm missing something. Thanks a lot for your help.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Hi Jose, correct, you need to set up the relationships in your model. If you download the sample file for this video (link in video description) you'll see the relationships. I also cover setting up relationships in my Power Pivot and DAX course: www.myonlinetraininghub.com/power-pivot-course
@sergiomandujano
@sergiomandujano Жыл бұрын
Thank you Mynda, can you please help on , how can I use a Measure in a DAX formula? For example... Column 2= CONTAINSSTRING(Table1[Column1],[Measure]) if I use this it will show TRUE regardless if Column1 contains or not the [Measure]
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
CONTAINSSTRING is looking for text, not a measure. Perhaps you need a different function. You're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@findthetruth3021
@findthetruth3021 2 жыл бұрын
Can you give us an example to compare more than two columns in two lists? because recently I have got a written test. They have asked me to compare two Databases, DB1 and DB2. To find the mismatches as well as finally I should have given them by the percentage of the difference between the two DBs. Could you please tell me how to do that? I have no clue if these a formula to compare between two datasets more than 10 columns and 300 rows for the DB1 and DB2, then give them the percentage of the difference between them. Thanks in advance, I have searched youtube and google too, but could not find anything like that to compare and give the percentage as well. This was the question Please use the databases in the sheets named (Database1) and (Database2) to find the percentage of discrepancy/mismatch between the two databases for the columns (from column D to column K in both Database1 and Database2 sheets). *Note: please use formulas to solve this question and keep them (don't delete any) also keep all the steps that you use to solve this question. If you only added the result/number without the formulas and without the steps then you will not get any point on it.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
If you have to use formulas, then you can use the EXACT function to compare ranges of data. From there you can calculate the percentage of records that are different. Hope that points you in the right direction.
@user-ed7xk7lt1j
@user-ed7xk7lt1j Жыл бұрын
How do I follow you?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
I'm everywhere: kzfaq.info twitter.com/onlinetrainingh facebook.com/MyOnlineTrainingHub/ www.linkedin.com/in/myndatreacy/ instagram.com/mynda.treacy/ www.tiktok.com/@myndatreacy?lang=en www.pinterest.com.au/myndatreacy/
What is DAX?
17:48
Access Analytic
Рет қаралды 39 М.
📊 How to use Power BI DAX - Tutorial
37:28
Kevin Stratvert
Рет қаралды 1 МЛН
LOVE LETTER - POPPY PLAYTIME CHAPTER 3 | GH'S ANIMATION
00:15
Best father #shorts by Secret Vlog
00:18
Secret Vlog
Рет қаралды 16 МЛН
Was ist im Eis versteckt? 🧊 Coole Winter-Gadgets von Amazon
00:37
SMOL German
Рет қаралды 38 МЛН
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 119 М.
Power BI vs Excel Dashboards - And the winner is...
11:55
MyOnlineTrainingHub
Рет қаралды 271 М.
How to Fix Incorrect DAX Measure Totals and What Causes Them
7:51
MyOnlineTrainingHub
Рет қаралды 32 М.
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 114 М.
5 HIDDEN Excel Tools Almost Nobody Is Talking About
9:00
MyOnlineTrainingHub
Рет қаралды 38 М.
DAX and the Data Model
19:03
Access Analytic
Рет қаралды 19 М.
Get started with DAX using QUICK MEASURES in Power BI
20:18
How to Power BI
Рет қаралды 30 М.
How to easily automate boring Excel tasks with Power Query!
17:10
MyOnlineTrainingHub
Рет қаралды 1,5 МЛН
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 214 М.
Choose a phone for your mom
0:20
ChooseGift
Рет қаралды 6 МЛН
Отдых для геймера? 😮‍💨 Hiper Engine B50
1:00
ИГРОВОВЫЙ НОУТ ASUS ЗА 57 тысяч
25:33
Ремонтяш
Рет қаралды 354 М.
Hisense Official Flagship Store Hisense is the champion What is going on?
0:11
Special Effects Funny 44
Рет қаралды 3 МЛН