Need Slicer(s) to Filter Multiple Date Columns on Single Card

[Anonymous]

Hi

I need to filter my cards using the condition "OR" between two columns. Start Date and finish date

This numbers depends on two filters, Start Date and Finish Date.

I need one slicer to use as date filter between the both dates "Start Date and Finish Date" however I need to use "OR" instead And.

Is it possible?

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Sure, it's possible. kindly refer to the blog:

https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/ 

[amitchandak]

@Anonymous ,

Create a measure like

=
var _max =maxx(allselected(date),date[date])
var _min =minx(allselected(date,date[date]))

return
CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date]=_max || date[date]=_min))

[Anonymous]

Sorry didnt understand very well Should I use with start date and finish date?