We've been struggling to create something that should be fairly simple. We are trying to create a dimension that counts if date 1 and date 2 are within 7 days of each other. If these two dates are within 7 days of each other, they are assigned 'NEW'. Currently able to do it as a measure but must be a dimension. Seems obvious, yes?