Recently I had some trouble comparing empty dates, wich in sql server are
1/1/1753 . Seems like if I do a YEAR([mydate])=1753... it doesnt work properly.
The date type in DAX does not support dates before 1900.
For practical reasons, you may want to consider that it only supports dates past the 1st of March 1900.
The Data Specialist (Blog)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?