power bi dates measure

[Annemie19]

Hi there, 

I want to create a measure that will show only the dates that are before today and future days that are before 90 days from now. 

Thanks, 

Annemie

[amitchandak]

@Annemie19 , Try like

//date related to table

measure = calculate(sum(Table[value]),filter(all(Date), Date[Date]<=Today() || Date[Date]>=Today()+90))

or

measure = calculate(sum(Table[value]),filter(Date, Date[Date]<=Today() || Date[Date]>=Today()+90)) //date not filtered

[Annemie19]

thanks a lot for the help, 

Should (sum(table[value])) be the table name or date field name? 

I want the date to be displayed. 

I am getting the following error