Many of you may already thought that we can use
CALENDARAUTO()in DAX and we are good to go. Well, that’s not quite right. In many cases there are some
DateTimecolumns that must not be considered in our Date dimension. Like Birth Date or Deceased Date. More on this later in this post.
In this post I share a piece of code I wrote for myself. I was in a situation to identify the Start Date and the End Date of the date dimension many times, so I thought it might help you as well.
Read on for a solution when not all date columns are relevant.