Dashboard drill-through on date using a lookup reference

[dropGrass]

Hello all,

I have a dashboard based on 4 loosely-related tables from a custom data module. Each of these tables is configured with a Lookup reference to the same Calendar table (which contains columns for year, quarter, weekday, etc.)

I'm trying to create a drill-through report that can do the following:

• User right-clicks on the Year-Quarter axis of Table1's chart, let's say '2025Q1'
• Drill-through report takes '2025Q1' and uses it to filter all 4 tables, not just Table1.

I'm thinking of trying a bunch of coalesced CASE WHEN filters to pass the date regardless of which table is drilled on, but I'm wondering if there's a more elegant solution. This solution would need several filters to account for the different columns referenced in the Calendar table (LongDate, Year-Quarter, Year-Month, Weekday, etc.)