FYPeriodEnd NOT EOM or same day each year

@DMercier,

I am a very big proponent of the large single date table approach. I think it makes data modeling and DAX simpler, reduces the likelihood of error, makes the model more transparent to users and other developers who may have to work with this model in the future.

I always start with @Melissa’s Extended Date Table, and then add whatever individual specialized fields I might need.

– Brian

1 Like