Hi,
I have a fact table with a high volume of data that needs to be filtered by date at a data source level with a parameter. The fact table is related table is related to several dimension tables. How do I make that the date parameter is only applied to the fact table?
Thanks you so much
Hi Ester,
You can achieve this by creating a parameter for the date and using it in a calculated field that specifically filters only the fact table. If you using a data source with relationships , you can apply the filter within the fact table by creating a calculation like:
[Fact Table Date] >= [Start Date Parameter] AND [Fact Table Date] <= [End Date Parameter]
Then, apply this calculated field as a data source filter so it only affects the fact table and not the dimension tables. If you’re using a join-based model, ensure that the filter is applied before the join takes place to prevent unnecessary filtering on dimension tables. Try.
Best,
Deepak
