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?
IF DATEDIFF('day', [Date1], [Date2]) <= 7 THEN 'New' ELSE 'Old' END