New Field Requests

Oct 6, 2011 at 1:25 PM

Thoughts on adding these new fields?

  • IsWeekend
  • IsUSHoliday
Oct 8, 2011 at 12:21 AM

Hi Anthony,

Thank you for your suggestions.

The IsWeekend can be easily done in PowerPivot with an expression checking whether the weekday is Saturday or Sunday, but I could add it in anyway to make it easier. As for the Public Holidays, I don't know how it works in the USA, but here in Australia they tend to change. There are some which are on the same date every year (like Christmas, 4th of July, 26th of January (Australia Day)), but some others are not straight-forward. Updating them annually would be a problem, especially if we have to do it for all localised versions, which are coming soon. If we come up with some way of splitting the work, so that different people own each Basic table, then I guesss we can try to achieve something like that. I know it is a very desirable feature and I am keeping it in mind.