HI Leo ,
Step 1: Create Start Date and End Date Parameters
- In the Data window, click the drop-down arrow at the top right of Dimensions, and then select Create > Parameter.
- In the Create Parameter dialog box, name the parameter. In the example workbook, the parameter is named Start Date.
- Under Data Type, select Date & time.
- Under Allowable values, select Range.
- Click Set from Field and select the date field. In the example workbook, the date field is named Order Date.
- Click OK.
- Right-click the Start Date parameter and then select Show Parameter Control.
- Repeat steps 1-7 to create the End Date parameter.
Thanks for that. I have done that, it's what Tableau recommends we do to create a date prameter.
But it's still seems weird that the Inner Join is ignored in this case.
This is intentional. It's done for performance reasons - it is usually much faster to get the domain of a dimension table if you don't also check that all the values are in the fact table. It's also useful in case data is added in the future.
Once you create an extract, everything is pre-joined so there's no need for this optimization.