Power BI date range custom column for filter

Question

How can I have a calendar, one table occupied with the date and another table occupied with the predicted date 

ReportRange = IF(DATESBETWEEN (Calendar[SQL_Date], (TODAY()-7), (TODAY()+7)),1,0)

I have tried with it and no syntax error,but when I click ok I got a warning,How can I resolve it?

Answer 1

Under filter, open date filter and choose advance filtering and create a logic

Use a slicer between to and from the list

 

Check the Power Bi Training  provided by Intellipaat