Dates differences between Excel and DAX
DAX supports dates starting in 1900 and while teaching DAX I always explain that DAX manages dates like Excel, which is the reason why these limitations exist. Actually, this is true – but answering to a comment today I realized I could explain this better.
DISCLAIMER: what follows will be hardly useful in your daily job. If you continue reading this post, you will do that just for the sake of your curiosity.