I'm trying to figure out this design.
I have a count measure "Count(ids)" in my fact table. I also have the standard date dimension which is joins up to fine. I'm trying to figure out where to put my YTD Dimension or if it goes into the standard date dimension. The measure is the count(ids) from the beginning of the year to the most current Saturday. Do I put the ytd field in the date dimension or should I make it it's own dimension.