7 Common Mistakes in DAX

0:00 Intro
0:17 DAX is NOT like Excel
0:56 DAX Writing Conventions
2:37 Measures are NOT the rows of a Table
5:03 Understanding Table Functions and Scalar Functions
7:00 Totals are NOT summation of displayed rows in the Visual
7:45 The holding Table does NOT impact the Measure output
8:35 Format your DAX
9:32 Adding Comments to your DAX

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[hydham]

By far one of the best videos about context transitions in DAX. 🙏🙏

[frankschadler]

Thank you, Chandeep.

It is a very good summary.

Table function are sometimes hidden, e.g. Lastdate(Date), correct would be max(Date), but it works.

[stephanweaver]

", you have to create row context..." - I have not heard anyone person say it that way before. Very helpful

[FlavioCastellaniFlaviotti]

Thanks for the video. I really like the fact that your videos are dense, straight to the point and rich of valuable info. One question pops up in my mind regarding scalar vs table functions. It seems that certain functions require neither one of the two, but, if I understand correctly, a one column table. Take max, for example. It is not possible to do a max of values. It could be interesting in expanding on that aspect, and its implications.

[dilipkumar-cknc]

Great video and Iam attending for the interview of powerbi can u give us any suggestions on resume and tips for interview

[ajieapen]

While DAX and Excel are dissimilar, I have found that "thinking in Excel" helps with writing DAX measures.. :)

[sravankumar]

why did you choose selected value function in for growth %

[sbn]

Usefull videos, DAX often surprises me. Somtimes it's very simple somtimes too hard

[williamarthur]

Can you add comments to a measure in power pivot? as I have not been able to do so,
also in power query, I sometimes find they are only visible in advanced editor, occasionally I can still see them in the formula bar.

[carlosmontejo]

You clearly have a good grasp of Power BI knowledge. But to be a good teacher, you must naturally slow down your speech and provide multiple explanations or examples of your thoughts. If you make these adjustments, you will be great. I have seen a couple of your other videos, so I believe you are capable of better output than this video. Yes, I am aware that YouTube has a video speed modulator.

[BestICan]

Mistakes 3 & 4 are huge for beginners.

[sandeepreddy]

Good one Chandeep. I always love your content.

[williamarthur]

Well I've just had a dig around and found the answer, yes, sort of,
the comments needs to be surrounded by other lines ;
Measure // comment ; will be deleted

Measure
// comments, will be deleted
but;
Measure
// comments
+0 , will remain. not ideal.