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

[@sagar5238]

Highly underrated channel. I learn new things in every video. Thanks a lot.

[@MyOnlineTrainingHub]

Thanks so much, Sagar! Please spread the word about our channel 🙏

[@sagar5238]

@@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]

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]

Thanks for your support, Vijay!

[@wayneedmondson1065]

Hi Mynda. Lots to learn in DAX! Thanks for the demo and intro. Thumbs up!!

[@MyOnlineTrainingHub]

Sure is, Wayne!

[@rachaelhanna8523]

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]

Thanks for your kind words, Rachael! Please share the video with your co-workers.

[@remuslupinhp]

Explained like a pro!

[@MyOnlineTrainingHub]

Thanks so much 😊

[@Khan-mc3gi]

You explain in a great way and you helping alot specially who dont know about power b.i u are great👍

[@MyOnlineTrainingHub]

So nice of you 😊

[@johnkuczmanski6012]

I followed along using the supplied Excel spreadsheet and learned a lot. Thanks.

[@MyOnlineTrainingHub]

Great to hear!

[@MOHDANWARify]

One of the best videos for beginners in Dax. Thanks so much

[@MyOnlineTrainingHub]

Glad you think so!

[@labc2007]

Thank you Mynda, clear, simple and useful leverage knowledge.

[@MyOnlineTrainingHub]

Glad you liked it, Luis 😊

[@shiffamohammed5818]

Thank you for the very much simplified to understand and clear explanation of DAX.

[@MyOnlineTrainingHub]

Glad you liked it, Shiffa!

[@JuanHernandez-pf6yg]

Very useful. Thank you! Lovely accent too.

[@MyOnlineTrainingHub]

Thank you! 😃

[@mogarrett3045]

Mynda you're the best

[@MyOnlineTrainingHub]

Thanks so much 🙏

[@mogarrett3045]

@@MyOnlineTrainingHub you're always welcome my friend

[@JHatLpool]

Nice demonstration and explanations. Thanks !

[@MyOnlineTrainingHub]

Glad it was helpful!

[@teoxengineer]

So great tutorial Mynda! very powerful and clear.

[@MyOnlineTrainingHub]

Thank you so much, Emre!

[@ozziepilot2899]

Excellent presentation , thanks.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@chrism9037]

This was excellent, thanks Mynda!

[@MyOnlineTrainingHub]

Glad you enjoyed it, Chris!

[@captainteach007]

Nice video! Good introduction to the topic.

[@MyOnlineTrainingHub]

Glad you liked it!

[@diegoaduriz9433]

Stunning explanation. Thx for sharing!

[@MyOnlineTrainingHub]

So glad you liked it, Diego!

[@fusimonyolo4585]

This is future; Thank you

[@MyOnlineTrainingHub]

My pleasure 😊

[@wodibalanakassoukpala2472]

Thanks for this video... Waiting for more videos on DAX from you

[@MyOnlineTrainingHub]

More coming 😉

[@joseluismartincenjor8409]

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]

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

[@jps11086]

Thanks for sharing your knowledge😀

[@MyOnlineTrainingHub]

My pleasure 😊

[@katarzynakosacka7531]

Thanx for this session! I love your videos.

[@MyOnlineTrainingHub]

Thanks so much 😊

[@darrylmorgan]

Hi Mynda!Great Starter Tutorial..Thank You :)

[@MyOnlineTrainingHub]

Thanks for watching, Darryl!

[@ghostlyverse2722]

You always rock making ever think so so easy

[@MyOnlineTrainingHub]

Thanks for your kind words!

[@drewbbc7074]

Nice starter tutorial. For me - DAX studio (developed by an Aussie) was key to writing elegant DAX.

[@MyOnlineTrainingHub]

Cheers, Drew!

[@lilianm7151]

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?

[@Chandrajith100]

Thanks a lot for the video!!!

[@MyOnlineTrainingHub]

You’re welcome! 😊

[@tanveerabbas3271]

cool n useful as always❤

[@MyOnlineTrainingHub]

Thank you! 😃

[@rd98868]

Amazing as always Mynda :)

[@MyOnlineTrainingHub]

Thanks so much!

[@KrishnaKumar-zn9kg]

Like it. Simple explanation.

[@MyOnlineTrainingHub]

Glad you think so!

[@RossMaynardProcessExcellence]

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]

Cheers, Ross! Good idea for top DAX functions 😊

[@RossMaynardProcessExcellence]

@@MyOnlineTrainingHub Thank you. No commission necessary!

[@NoTengoIlusiones]

A big Thank you !

[@MyOnlineTrainingHub]

My Pleasure :-)

[@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]

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

[@GeertDelmulle]

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]

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]

@@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. ;-)

[@abderrahmaneazibi8056]

Many thanks!

[@MyOnlineTrainingHub]

My pleasure :-)

[@shoctors]

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]

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.

[@kayalha]

Thank you for the very much

[@MyOnlineTrainingHub]

My pleasure 😊

[@hubertg7100]

Amore 💕💕

[@MyOnlineTrainingHub]

Glad you liked it 😊

[@findthetruth3021]

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]

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.

[@asepridwan3362]

I Will subscribe your KZbin channel Mrs.thanks from Indonesia

[@MyOnlineTrainingHub]

Great to have you subscribe!

[@asepridwan3362]

@@MyOnlineTrainingHub done👍

[@ExceluniForAll]

thats great

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@IFECHUKWUDENWOKO]

How do I follow you?

[@MyOnlineTrainingHub]

I'm everywhere: kzbin.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/