New Cheat Sheet for Extended Date Table


Attached is an updated version of the “cheat sheet” for @Melissa’s awesome Extended Date Table.

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.


Just adding some keywords to make this easier to locate via forum search: date table, extended, cheat sheet, time intelligence, fields, format, fiscal, year, calendar.


Awesome this is super

The best date table generator I’ve seen.

Our business is operates on various days/per week. As an industrial contractor, we have projects that work various work weeks. Our work week is defined by our contract obligations

4 days x 10 hrs/day = 40 hrs per week
5 x 8’s = 40 h/w
5 x 10’s = 50 h/w
6 x 10’s = 60 h/w
7 x 10’s = 70 h/w
7 x 12’s = 84 h/w

as well as day shifts and night shifts
can anyone help with the adding to the function to be able to provide additional parameters?

This would be a very valuable addition in my opinion. thanks


Hi @mccracken.

Please create a new thread with your question … replying to a solved thread will reduce the visibility of your question.

Also, I’m a little unclear on what you’re issue is; can you please describe more fully what you’re looking for:

  • a date table that can be used for many different work weeks?
  • a separate “work week” table that can be assigned/used on a project-by-project basis?

And finally, please provide your work-in-progress PBIX file and a mockup in Excel of your desired outcome to help the forum members weigh-in.