Inclusive Page / Visual Filters

[omdavies]

Is it possible to configure a report to filter inclusivly ?  Scenario to use is:

Table of Incidents 

Title

Status

Open Date

Close Date

I would like to create a table of incidents that are either open or closed after 1st December 2020.  Ideally this date would be based on date slider.   It would be simple to implement an AND, but that is not what I am after.

Any thoughts on how/if this can be achieved ?

[Anonymous]

Hi @omdavies ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.Thank you.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @omdavies ,

According to my understand, when select 2021 in Close Date ,you want to display one of the open date and close date is 2021. For example, the following data meet the conditions, right?

open date	close date
2020/1/1	2021/1/2
2021/1/3	2020/1/4
2021/1/5	2021/1/6

If so , you need to create a single table for close date and use the following formula:

Measure =
IF (
    YEAR ( MAX ( 'Worksheet'[Open Date] ) )
        IN ALLSELECTED ( 'Table'[Close Year] )
            || YEAR ( MAX ( 'Worksheet'[Close Date] ) ) IN ALLSELECTED ( 'Table'[Close Year] ),
    1,
    0
)

Then apply the measure to filter pane ,set as "is 1". The final output looks like this:

Here is the pbix file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Eyelyn Qin

[Pragati11]

Hi @omdavies ,

I don't understand your requirement completly. Can you share some sample data with input and expected output?

Thanks,

Pragati

[omdavies]

Hi, below is an example.  The way it is saved shows all Open AND close date of 2021.  What I want is open OR close date of 2021.  So for example it could show those that are closed but close date in 2021.  Does that make sense ?

https://remarkabledynamicsltd-my.sharepoint.com/:u:/g/personal/owen_remarkabledynamics_com/EfbDWjvIl...