Forum Discussion
Solved
Dates Colum left Merge
Hi all I really hope someone can help please I have 1 x dataset with 4 date columns each relating to something different fulfilled date 1 fulfilled date 2 fulfilled date 3 fulfilled d...
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:
Several approaches.
- You can use a purely active and a single direction many-to-many relationships (requries some data manipulation)
- Or use an active and inactive relationships and use measures to show the visible rows.
-
Please see the attached pbix.