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.
Please do not ask new questions in already solved threads, they are impossible to locate…
Always create a new Topic in the appropriate category and provide all relevant data and details (a picture is not very ‘support’ friendly a xlsx or csv in this case is)
Review the items in this category for additional tips and tricks to get the most out of this forum.