Is it possible to Date Filter ( Min to Max - 1). Please advise.

[Vinothsusai]

Hi,

I have a date filter in the visual that can select min date and max date. If i select the min and max date, that visual should filter min date to Max date - 1. Please advise.

Thanks

Vinoth

[amitchandak · Accepted solution]

@Vinothsusai , Try like

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

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