Understanding the difference between LASTDATE and MAX in DAX

[DIGITAL_COOKING]

DAX IS THE MOST BEAUTIFUL LANGUAGE FOR ME, AND WITH YOUR HELP IT IS MORE ENJOYABLE
👍👍👍👍👍👍🙂

[nikakalichava]

Thanks a lot, And to anyone reading the comments, yeas you need to add +1. in the end of the formula. sometimes even the best blank out.
Thanks Albarto!

[venkatareddykummitha]

Really sir the way your explanation with slowness is good.

[feo]

Unrelated note, you need to add 1 to your formula to get the correct number of days in the period.

[tareksalha]

This episode potentially marks a new chapter of sqlbi videos, because Alberto said “have fun with DAX” instead of “enjoy DAX”. This was so unanticipated for all viewers that it has to have some deeper and subtle meaning. 🤔 enjoying something means having pleasure with it in an honest and serious manner, while having fun is much more connected to leisure and free time. Thus, I conclude, DAX is going to be degraded in future from a working horse tool for serious BI applications processing billions of rows in milliseconds to a ludicrous play language for silly people.
Bill Gates has planned this on a long term to subjugate us! 😱 And even worse, Marco and Alberto are his secret fellows! I am awake now. 😅

[mohamedfasil]

Thank you sir for making wonderful videos for us.
I am looking for solution from please help me on this, How to find second max date of particular customer in using Dax ?

[TcheQ]

Is it faster to use datediff here? Also surely you want to add 1 to this equation as every month, Cy2008 and total has the wrong number of days (365 is incorrect as CY2008 is a leap year)

[jaimeildefonsosegurapena]

Alberto, ti sei dimenticato di aggiungere +1 in Days in period...

[williamarthur]

Ciao, so this is why I can't use MAX inside STARTOFMONTH ?
Out of interest would you recommend using MAX or LASTDATE as the third argument in DATESBETWEEN,

DATESBETWEEN('Calendar'[Date], STARTOFMONTH(LASTDATE(fSales[Date])), MAX(fSales[Date])))

I usually decalare max as a variable. BTW really enjoyed the chapter on variables, never occurred that they weren't affected by calculate once declared . 😊

[golodiassaid]

Question! scratching my head whole day and I couldn't come up with any good solution. Basically how would you compare two tables? Each are huge and visually impossible to tell if they are the same or one has rows the other doesn't. They have exactly same number of columns and column names.I tried EXCEPTH func but it get error " Function 'EXCEPT' does not support joining a column of type Number with a column of type Text.). Any suggestions?. Again thanks for excellent content!

[dominikpetri]

Thanks for the great explanation. One question remains: Why do you need INT()?

[yyymmmddd]

Good explanation. But what is the purpose of LASTDATE/FIRSTDATE functions then?

[smritishukla]

So what if the condition is to select Value from separate column for max and min of date?
Could you please help here? Thanks!

[Bharath_PBI]

Thank you. SQLBI Newsletter and YouTube videos going together. Appreciate it 👍

Are there any links or videos that explains DAX query plans and it's operators in depth ?