I keep this on my desktop and find it really useful to remember things like:
- “What’s the difference between Month & Year, MonthnYear, MonthEnding, and MonthCompleted?”,
- “What field do I use to sort Short Month by so that it shows up chronologically rather than alphabetically in my visuals?”
- “Is the IsHoliday field coded 1/0 or TRUE/FALSE”?
Also, @Melissa and I are doing a multi-part video series on the Enterprise DNA TV YouTube channel focused on using the Extended Date Table to simplify your time intelligence calculations. The first video in the series, How to Create a Holiday Table, is already up and the next two episodes, Creating the Extended Date Table and Date Harvest Deep Dive, should be posting soon.
Hope this is helpful to you.