Dates Colum left Merge

Hi KarenFingerhut ,

You have two options you can go with:

Option 1: Create inactive relationships and calculate against those dates. You can trigger the relationship by adding the function USERELATIONSHIP to your measure(s). Not scalable but something to consider.

Option 2: Unpivot your columns to go "long" rather than "wide". Then connect your date table to your single one date column. Most preferred method.

Here's an example of how each would look like with their relationships: