Filter

[Anonymous]

Hello.

I need to customize a date filter to select dates from a specified month to a specified month.
For example from drop-down list (February) to drop-down list (June).

I need to select beginning and ending month from a drop-down list each, and not from a slicer.
Is that possible in Power BI?

Thank you.

[Tahreem24 · Accepted solution]

@Anonymous Or most easiest way is to use the BETWEEN slicer. So, it will give you the range to select between two date range. Easy-Peasy one.

[amitchandak]

@Anonymous , You need to create two slicers, based on independent date tables and use them.

So will have two date tables date1 and date2 with month year and use them in two slicer

new meausre =
var _max =maxx(allselected(Date2), Date2[Date])
var _min =minx(allselected(Date1), Date1[Date])
return
calculate(sum(Table[Value]) , filter(Table, Table[Date]>=_min && Table[Date]<=Max))