How and where to write DAX Measures for Power BI and Excel
Vložit
- čas přidán 28. 06. 2024
- 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 - Věda a technologie
Highly underrated channel. I learn new things in every video. Thanks a lot.
Thanks so much, Sagar! Please spread the word about our channel 🙏
@@MyOnlineTrainingHub although I am not a youtuber content creator. But I would like to suggest you to create short videos. Then traction may improve.
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! 😊👍
Thanks for your support, Vijay!
Thank you for the very much simplified to understand and clear explanation of DAX.
Glad you liked it, Shiffa!
Thank you Mynda, clear, simple and useful leverage knowledge.
Glad you liked it, Luis 😊
I followed along using the supplied Excel spreadsheet and learned a lot. Thanks.
Great to hear!
Hi Mynda. Lots to learn in DAX! Thanks for the demo and intro. Thumbs up!!
Sure is, Wayne!
One of the best videos for beginners in Dax. Thanks so much
Glad you think so!
Very useful. Thank you! Lovely accent too.
Thank you! 😃
So great tutorial Mynda! very powerful and clear.
Thank you so much, Emre!
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
Thanks for your kind words, Rachael! Please share the video with your co-workers.
You explain in a great way and you helping alot specially who dont know about power b.i u are great👍
So nice of you 😊
This was excellent, thanks Mynda!
Glad you enjoyed it, Chris!
Thanx for this session! I love your videos.
Thanks so much 😊
Hi Mynda!Great Starter Tutorial..Thank You :)
Thanks for watching, Darryl!
Stunning explanation.
Thx for sharing!
So glad you liked it, Diego!
Thanks for this video... Waiting for more videos on DAX from you
More coming 😉
Nice demonstration and explanations. Thanks !
Glad it was helpful!
You always rock making ever think so so easy
Thanks for your kind words!
Explained like a pro!
Thanks so much 😊
Thanks for sharing your knowledge😀
My pleasure 😊
Thanks a lot for the video!!!
You’re welcome! 😊
Nice starter tutorial. For me - DAX studio (developed by an Aussie) was key to writing elegant DAX.
Cheers, Drew!
A big Thank you !
My Pleasure :-)
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!
Cheers, Ross! Good idea for top DAX functions 😊
@@MyOnlineTrainingHub Thank you. No commission necessary!
Amazing as always Mynda :)
Thanks so much!
Many thanks!
My pleasure :-)
Mynda you're the best
Thanks so much 🙏
@@MyOnlineTrainingHub you're always welcome my friend
Like it. Simple explanation.
Glad you think so!
This is future; Thank you
My pleasure 😊
So that's what my name stands for, thanks! 😀
😁 Yep!
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?
Thank you for the very much
My pleasure 😊
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]
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.
@@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. ;-)
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?
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.
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.
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
I Will subscribe your CZcams channel Mrs.thanks from Indonesia
Great to have you subscribe!
@@MyOnlineTrainingHub done👍
thats great
Glad you liked it 🙏
Amore 💕💕
Glad you liked it 😊
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]
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
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.
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.
How do I follow you?
I'm everywhere:
czcams.com/users/MyOnlineTrainingHub
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/