Forum Discussion
Filter on time interval
Hi brunborg ,
Firstly, remove the relationship between Event table and data table, create relationship between data table and month table.
The create a measure like below:
Measure =
IF (
MIN ( Events[Start Date] ) IN VALUES ( 'Date'[Date] )
|| MIN ( Events[End Date] ) IN VALUES ( 'Date'[Date] )
|| (
MIN ( Events[Start Date] ) < MIN ( 'Date'[Date] )
&& MIN ( Events[End Date] ) > MAX ( 'Date'[Date] )
),
1,
0
)Then drag this measure to FILTERS, set it like below:
The result will like below:
Best Regards,
Teige
Hi brunborg ,
Firstly, remove the relationship between Event table and data table, create relationship between data table and month table.
The create a measure like below:
Measure =
IF (
MIN ( Events[Start Date] ) IN VALUES ( 'Date'[Date] )
|| MIN ( Events[End Date] ) IN VALUES ( 'Date'[Date] )
|| (
MIN ( Events[Start Date] ) < MIN ( 'Date'[Date] )
&& MIN ( Events[End Date] ) > MAX ( 'Date'[Date] )
),
1,
0
)
Then drag this measure to FILTERS, set it like below:
The result will like below:
Best Regards,
Teige
Hi,
I've got the same data structure in various databases and this solution works but...
It takes a looooong time to filter when aplying to not so large tables. I`ve got a table with no more than 5k records and when I try to filter the data the process starts but never ends with the result.
Is there any other more efficient approach to get this done? I have to use the same technique with other databases that reach to more than 1M records and this solution doesn't seem to be useful in that case.
Thank you!