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:
- Unpivot your 4 date columns into one column using Power Query.
- Create a Date table with Year, Month, and Date columns.
- Link the unified date column to the Date table.
- Use slicers from the Date table to filter visuals.
- This setup lets you filter by any date across all 4 columns—cleanly and scalably.