Forum Discussion
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:
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:
Hi hnguy71
Option 1 worked a treat, I then created USERRELATIONSHIP measures for the visual
Thanks very much 😁
Kind regards
Karen
you're welcome!