Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

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)

No syntax error

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

1 Answer

0 votes
by (22.5k points)
edited by

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

enter image description here

Use a slicer between to and from the list

enter image description here 

Check the Power Bi Training  provided by Intellipaat 

Related questions

0 votes
1 answer
asked Feb 10, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jan 13, 2021 in BI by Chris (11.1k points)

Browse Categories