Forum Discussion
jsteffe
Helper III
Helper IIIDate period filter
Hello, I manage animal movements in buildings. I get this table MOVEMENT : ID_movement, entry_date (in the building), exit_date (of the building), number of animals, building_id When I choos...
Hi jsteffe ,
According to your description, here's my solution.
Create a measure:
Measure = IF ( MAX ( 'Table'[start date] ) <= SELECTEDVALUE ( 'Date'[Date] ) && COALESCE ( MAX ( 'Table'[end date] ), TODAY () ) >= SELECTEDVALUE ( 'Date'[Date] ), 1, 0 )Put the measure in the visual level filter and select "is 1".
After apply filter, get the correct result:
I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I didn´t get the question right, but it seams, that you would need to use IF here.
jsteffeid_movement Building_ID start date end date number of animals 1 A 01/01/2023 30/03/2023 150 2 A 15/02/2023 25/05/2023 120 3 B 01/01/2023 10/01/2023 10 4 B 02/02/2023 16/04/2023 15 5 C 01/04/2023 25 With this date, if I choose 20/04/2023, I get 2 buildings that are not empty : A and C.
How to get these 2 buildings ?