Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat

Lately I've been working with incremental refresh and found that while RangeStart changes with the settings for incremental refresh the...

Incremental refresh requires a DateTime field and many tables come from the database instead with the DateID column. Here is how to...