Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
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
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:
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
Hi @omdavies ,
I don't understand your requirement completly. Can you share some sample data with input and expected output?
Thanks,
Pragati
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 ?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |