Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Trying to figure out how I can create a date slicer that can filter accross multiple date columns simeltaniously. I've created a date dimension table, however, I can only create a single active one-to-many realtionship whichs limits me to filtering on only 1 of the 5 date columns at once. I need the visuals to update according to their respective date columns. How can I resolve this?
You can have multiple relationships between a lookup table (like a date table) and a fact table. However, only 1 can be active at a time. So if you want to leverage an inactive relationship, you would use the function USERELATIONSHIP().
The syntax is pretty straightforward. Basically, you would use it as a filter criteria in a CALCULATE function, something like:
CALCULATE(SUM([SALES]),USERELATIONSHIP('DATE_TABLE'[DATE],'SALES_TABLE[SECONDARY_DATE])
Hope that helps.
User | Count |
---|---|
85 | |
82 | |
66 | |
53 | |
47 |
User | Count |
---|---|
102 | |
50 | |
42 | |
39 | |
38 |