Difference between LASTDATE and MAX for semi-additive measures in #DAX
I recently wrote an article on SQLBI about the semi-additive measures in DAX. I included the formulas common calculations and there is an interesting point that worth a longer digression: the difference between LASTDATE and MAX (which is similar to FIRSTDATE and MIN - I just describe the former, for the latter just replace the correspondent names).
Read more...