Difference between LASTDATE and MAX for semi-additive measures in #DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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...

Tags: dax

 

2007-2015 VidasSoft Systems Inc.